Hi all, I'm trying to use a filter inside an aggregation.
My data looks like this:
On a page, I want to add a slicer/filter that would allow a user to choose a fruit. This would filter the line chart below which would show % of count that the fruit makes up each day. So if a user selects apple, the line chart would have a mark at 40% for Jan 1, 30% for Jan 2, and 20% for Jan 3.
In Tableau, I would set up a list parameter (p_fruit) containing all possible fruits and then build a calculation something like this:
Sum( Case( when fruit = p_fruit then Count else 0 END) )
/
sum (count)
Does Domo have a similar functionality for using parameters to impact aggregations?