Tableau-like parameter actions

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 🥷
    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**


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

  • @gbuckley ,

    you could

    fruit as ReportFruit
    From table
    '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.


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

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"