Tableau-like parameter actions

gbuckley

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?

GrantSmith

Hi @gbuckley

Domo doesn't have parameters to pass in using this type of a method. Typically the closest you can get is using a webform to store your parameter and join that to your dataset using a dataset view. It's not the best user experience though.

Jessica

I am thinking you would have to make that percent part of the dataset?

jaeW_at_Onyx

@gbuckley ,

you could

select
*,
fruit as ReportFruit
From table
UNION
select
*
'all fruit' as ReportFruit
 from table

then put ReportFruit as the Filter, you have to always include the 'all fruit' as well as the desired fruit.

then

sum(case when ReportFruit <> 'all Fruit' then amount) /
sum(case when ReportFruit = 'all Fruit' then amount) /