Multi-value column card to Compare Turnover
My intent is to create a multi-value column card to compare turnover data from the current year to the previous year.
Ideally, I'd have it compare the year to date terminations/turnover to the previous year's at the same point in time. I'd like to display the total number of terminations for this year and either a % increase/decrease compared to last year or merely an absolute value increase/decrease.
My dataset has a column for termination dates going back the past 6-7 years.
- I'm unsure if I need to create new variables in beast mode for comparing to the year prior. And if I do, what I need to do
- This is my first time trying to make a multi-value column card- I'm not sure how to set this up
- I set up dropdown filters for the other cards in my dashboard. Is there a way to select which filters can/can't impact this particular card?
Best Answer
-
Hi @Kutsch! Let's see here. These snapshots should help you out.
As a precaution, group your data by date, then have an aggregated column of terminations summed.
Then go into a card and select period over period multi value chart. See below. To ensure filters aren't applied , edit dash > click on card edit content arrow > change filter exceptions > toggle allow filtering. Hope this helps you out!
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0
Answers
-
Hi @Kutsch! Let's see here. These snapshots should help you out.
As a precaution, group your data by date, then have an aggregated column of terminations summed.
Then go into a card and select period over period multi value chart. See below. To ensure filters aren't applied , edit dash > click on card edit content arrow > change filter exceptions > toggle allow filtering. Hope this helps you out!
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0 -
@pauljames Looks like it's working for me. Thanks!
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive