Forum Discussion

HarrisonRay's avatar
HarrisonRay
Qrew Member
3 years ago

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...
reports and charts
HarrisonRay's avatar
HarrisonRay
Qrew Member
3 years ago
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
------------------------------