Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Example Scenario

Topic Labels: Automations
160 2
cancel
Showing results for 
Search instead for 
Did you mean: 
billierios
4 - Data Explorer
4 - Data Explorer

Assume you have a total of 100 items and a multi-select field that allows you to select from a set of values. You want to find out what percentage of the total is represented by the selected values.

2 Replies 2

Could you provide an example of this and what you would want the output to be?  For example, is the data in the screenshot below set up the way you expect?  If it is, what would some examples of output be?

Screenshot 2024-09-30 at 10.34.27 PM.png

Dan_Montoya
Community Manager
Community Manager

Use a "reporter" field. This is a linked record to a new table called reporter.  Each one of your items will link to "reporter."  In reporter you can use a "count" field to count the items that use select A, select B, etc. as a percent of the total.

 

Screenshot 2024-10-02 at 8.33.24 PM.pngScreenshot 2024-10-02 at 8.35.27 PM.png