Tableau-like parameter actions

gbuckley
gbuckley Salt Lake City, UT ⚪️

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?

Best Answer

  • GrantSmith
    GrantSmith Indiana 🔴
    Accepted Answer

    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.

Answers

  • Jessica
    Jessica ⚪️

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

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    @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) /