Sep 30, 2024 02:25 AM
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.
Sep 30, 2024 07:35 AM
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?
Oct 02, 2024 08:35 PM
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.