Parameter Filer

Anna_Yu · 2023-08-31T18:28:01+00:00

There was an error rendering this rich post.

Hello everyone,

I wonder if someone has successfully figured out how to create a parameter filter in DOMO. I want to create a filter that allows dashboard readers to choose which two years they want to compare (e.g. 2021 vs. 2019 or 2022 vs. 2024). Thank you very much.

Best,

Anna

Quick Links

Accepted answers

ColemenWilson

Yep, so basically you would join your data 1=1 so that it looks like this:

Screen Shot 2023-08-31 at 2.40.27 PM.png

Then in your card you have your two values:
`data` and `comparison data`

Users select a year and a comparison year and the data for each will be displayed. I would suggest setting default values for each, for example: 2022 vs 2023 and then from there allow users to change the dates.

MichelleH

@Anna_Yu Do you always want the values to be red and black? If so, you can create two color rules so Year 1 is always red and Year 2 is always black. Here is a KB article on how to set up color rules: https://domo-support.domo.com/s/article/360043428813?language=en_US

MichelleH

@Anna_Yu You will also need to create beast modes for each year selected, like the ones in my original post. Those beast modes are what the color rules will be based off of, so if you named them differently that is what you will need to look for in the drop-downs

All comments

ColemenWilson

Could you provide a bit more information? This is possible, and I have done this - but I want to better understand the type of content you have on your dashboard and how you plan to compare one year vs another visually.

The approach I took was to build a dataflow that had comparison data self-joined to the data and then had a filter to allow end users to select the 2 periods they want to compare. With a bit more information I'll know if this approach could work for you.

MichelleH

@Anna_Yu This sounds like a good use case for Variables. I'd suggest creating two variables to select the years you want to compare. Here are some sample beast modes you could use with these variables:

Year 1 Total:

sum(case when YEAR(`Date`) = `Year 1` then `Amount` else 0 end)

Year 2 Total:

sum(case when YEAR(`Date`) = `Year 2` then `Amount` else 0 end)

Variance:

sum(case when YEAR(`Date`) = `Year 1` then `Amount` else 0 end) 
- 
sum(case when YEAR(`Date`) = `Year 2` then `Amount` else 0 end)

% Variance:

(sum(case when YEAR(`Date`) = `Year 1` then `Amount` else 0 end) 
- 
sum(case when YEAR(`Date`) = `Year 2` then `Amount` else 0 end))
/ 
sum(case when YEAR(`Date`) = `Year 2` then `Amount` else 0 end)

Anna_Yu

Hello Colemen,

Thank you for taking my questions.

Here is my example. I have three columns in my dataset: number of sales, profits, and year. I created profits per item (profits/sales) in beast mode. I have used the "multi-value columns" card to show my readers the differences between the two years (e.g. profits per item 2023 vs. 2022). My challenge here is my readers want to choose the years by themselves (e.g. profits per item 2023 vs. 2021), so I think a parameter filter can solve this.

Hope I explained well. Thank you!

Best,

Anna

ColemenWilson

Yep, so basically you would join your data 1=1 so that it looks like this:

Then in your card you have your two values:
`data` and `comparison data`

Anna_Yu

Thank you, Michelle and Colemen. :)

I have created the 'parameter filter' with variables. Now, I am facing another issue: the colours. Is it possible to automate the colour rules? For example, when someone uses 2021 to compare with 2019, all the 2021 data are marked as red and 2019 as black, and when someone uses 2022 to compare with 2019, all 2022 data are marked as red instead, and 2019 remains black.

Thank you very much!

Best,

Anna

MichelleH

Anna_Yu

Hello Michelle, @MichelleH

My Year 1 and Year 2 are variables, so they can be any value, but yes, I want my Year 1 always be red and Year 2 always in black. I checked the colour rule settings but don't see my variables listed there. Thank you!

Best,

Anna

MichelleH

Anna_Yu

Hello Michelle, @MichelleH

The beast mode is shown as numeric, so in the colour settings, I have to put a number in the condition (as below). If I put a number in it, it won't be dynamic anymore. Please let me know if I understand you correctly. Thank you.

Best,

Anna

MichelleH

@Anna_Yu You can leave the "is always" condition and the color will apply regardless of the value

Anna_Yu

Hello Michelle, @MichelleH

I left the condition blank, but the colour does not appear on my chart. Thank you!

Best,

Anna

MichelleH

@Anna_Yu Is the `current_year` field actively used in your chart? Color rules only apply to fields that are also displayed in the chart.

Anna_Yu

Hello Michelle, @MichelleH

It is not in my chart. My Y-Axis is category, X-Axis is sales, and SERIES is year. Thank you!

Best,

Anna

MichelleH

@Anna_Yu Try this instead:

Y-Axis: Category
X-Axis: Year 1 (Beast Mode)
Series: Year 2 (Beast Mode)

Anna_Yu

Hello Michelle, @MichelleH

It is working now 😀 Thank you so much!

Best,

Anna

other categories

Product Ideas
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ideas Exchange
Suggest & vote on new features you would like to see implemented in the Domo Product.
Data Connections
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Connectors
Connectors, Custom Connectors, Writeback
Workbench
Ask questions about Workbench, a secure, client-side solution for uploading your on-premise data to Domo.
Cloud Integrations
Ask questions about Cloud Integrations and Federated Data connection to your data warehouse or lake.
Data & ETL
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Magic ETL
Ask Magic ETL questions and get answers from Domo peers
SQL DataFlows
Ask SQL DataFlow questions and get answers from Domo peers
Datasets
Ask DataFusion and Dataset Views questions and get answers from Domo peers
Visualize & Apps
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Dashboards
Ask Cards, Dashboards, and Stories questions and get answers from Domo peers
App Studio
Ask questions about building apps in App Studio.
Pro-code Components
Ask questions about pro-code components and Domo Bricks and get answers from Domo peers.
Charting & Analyzer
Ask questions about charting and Analyzer and get answers from Domo peers.
Calculations & Variables (Beast Mode)
Ask questions about using calculated fields and Variables (Beast Modes) in Analyzer.
AI & Data science
Ask questions about DomoAI and get answers from Domo peers.
Domo AI & AI Chat
Ask questions about AI Chat and AI assistants.
Managing AI
Ask questions about managing AI with AI Playground, AI projects, AI models, and more.
Jupyter Workspaces
Ask questions about Jupyter Workspaces, Notebooks, and file share.
Automate
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Workflows
Ask questions about Task Center, building automations with Domo Workflows, and executing JavaScript or Python code with Code Engine.
Alerts
Ask questions about managing alerts in Domo and get answers from Domo peers.
Distribute
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Domo Everywhere
Ask questions about embedded analytics with Domo Everywhere.
Reporting
Ask questions about Scheduled Reports, Report Builder, and Slideshow Publications.
Manage
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Governance & Security
Ask questions about People, Groups, Roles, Sandbox, Activity log, Buzz, Teams, Approvals and PDP and get best practices from Domo peers
Navigation & Productivity
Ask questions about navigation, Projects & Tasks, Goals, and Buzz chat.
APIs
Ask APIs and Developer.domo.com questions and get answers from Domo peers
Add-ins & Plugins
Ask questions about plugins, Microsoft add-ins, and other third-party software integrations.
Domo Community Gallery
Watch how our Customers are using Domo to solve their complex problems.
Product Releases
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Domo University
Questions or discussions related to Domo University, trainings and certifications
Community Forums
Getting Started
Welcome to Domo's Community Forums! You'll find everything you need to get started in this category.
Community Announcements
Get the latest from Domo's Community Team.
Social Groups
Archive
Old or outdated content that could still be found helpful.