Date Range - Show 'Current Day' in one column and 'All Time' in the next column in one card
Is there a way that I could have two different date range filters by column on the same card?
In the attached screen shot I would like to show 'Trucks Running' and 'Assignments' filtered daily
and
'Registered Trucks' filtered by ALL TIME
and have them both shown on the same card.
Thanks
Best Answer
-
You can do this with a beast mode that uses some date conditions to make the calculation how you want it. And set the card to all time, not yesterday, since that filter will supercede everything else.
Trucks Running
aggregation(CASE WHEN `DATE` = current_date() THEN... END), using SUM or COUNT or whatever aggregation you currently have.
Assignments
Similar, with the assignment column, using whichever aggregation
Registered Trucks
If your card is filtered to all time, then you likely don't need this type of conditional logic and could probably use your existing beast mode.
Hope that helps!
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers
-
You can do this with a beast mode that uses some date conditions to make the calculation how you want it. And set the card to all time, not yesterday, since that filter will supercede everything else.
Trucks Running
aggregation(CASE WHEN `DATE` = current_date() THEN... END), using SUM or COUNT or whatever aggregation you currently have.
Assignments
Similar, with the assignment column, using whichever aggregation
Registered Trucks
If your card is filtered to all time, then you likely don't need this type of conditional logic and could probably use your existing beast mode.
Hope that helps!
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
I tried to run that calculation but not getting the values that I want. Am I doing something wrong??
0 -
I'm not sure how your data is set up, but you're comparing the ID of the individual truck to the date. That doesn't really compute. Counting unique 'true' values will give you either a 0 or a 1, which probably isn't correct either.
Maybe you need something more like
COUNT(DISTINCT(CASE WHEN [shipment date column] = CURRENT_DATE() THEN `truck_ID` END)
This would give you a count of all trucks that had shipments today.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive