I am trying to allow a user to filter a chart that uses an aggregation. My data looks like this:
I want a user to be able to choose 'Apple' and then the ensuing line chart would show percentage of items each day that were apple (40% over 1/1, 30% over 1/2, and 60% over 1/3).
In tableau, I would set up a parameter (p_fruit) containing all values in the 'Fruit' column. I would then set up an aggregation something like this:
sum( case when 'Fruit' = p_fruit then 'Items' else 0) / sum('Items')
Is it possible to recreate this type of functionality in Domo?