Dashboard display based on current time
I have a dataset with "Shift 1" and "Shift 2" values in the "Shift" column.
Shift 1 is midnight-noon and Shift 2 is noon-midnight.
what do you think the best way to have that dashboard update and only show the current shift based on the current_time would be, ideally using a beast mode so that during shift 2 you could toggle the dashboard with a slicer back to shift 1 if desired.
Best Answer
-
@JasonAltenburg yea I would do something with a BM that basically determines which one of the shifts is current (have one say current shift and then not current shift so you don't have issues with nulls ) then I would add that as a filter card to the top of the page as well as a filter card for the shifts. Select the current shift and save that as the default filter. People should be able to select not current shift if they want to see the other one.
You could also probably make 1 filter and do a concat so it says Current shift - Shift 1, Not current shift - shift 2
**If this answer solved your problem be sure to like it and accept it as a solution!
2
Answers
-
@JasonAltenburg yea I would do something with a BM that basically determines which one of the shifts is current (have one say current shift and then not current shift so you don't have issues with nulls ) then I would add that as a filter card to the top of the page as well as a filter card for the shifts. Select the current shift and save that as the default filter. People should be able to select not current shift if they want to see the other one.
You could also probably make 1 filter and do a concat so it says Current shift - Shift 1, Not current shift - shift 2
**If this answer solved your problem be sure to like it and accept it as a solution!
2 -
You can't dynamically tell a page to filter on different values (filter on shift 1 / filter on shift 2) depending on the time of the day. You'd likely need to have a beast mode that calculates the shifts as either "Current" or "Other" and then have a default page filter where shift = Current.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive