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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive