For more context, I have 1000's of entree. Each entry contains many fields, including date and include a multi-select text field.
So each entree has a bunch of data, a date, and these multi-select selections:
Entree 1 = multi-select "A", multi-select "B"
Entree 2 = multi-select "A", multi-select "C", multi=select "D"
Entree 3 = C
Entree 4 = D,B,A
Entree 5 = F,A,C
Etc.
1000's of entrees with unique combinations of multi-select "selections"
I want a line graph that shows date on the x axis and the number of times each "selection" had been chosen each day.
Thanks again!
------------------------------
Harrison Ray
------------------------------
Original Message:
Sent: 09-13-2021 14:47
From: Harrison Ray
Subject: Help Using a Report Formula for a Line Graph
Hello,
I want to visualize some data but am not entirely sure it's possible.
I currently have a multi-select text field in a table. I want to create a line graph showing the number of times per day each of those multi-select text options is selected.
So the x axis would be "date", the y axis is "# of times selected", and the graph has many series - each series being one of the individual multi-select text options.
I've been toying with report formulas and have figured out how to pull out one of the selections per formula. And the series references the report formula. I could make a report formula for each selection but still am only able to select the one series, so am not sure how to get the graph to display them.
Is there a way to have a formula that counts the number of times each of the multi-select options is selected?
Thanks for any help!
------------------------------
Harrison Ray
------------------------------