Dynamically show Dates
We have a collection of cards that all look like the image below, each for a different KPI (Demand, Traffic, etc). These cards are built utilzing beast modes that pull in MTD data based on a fiscal month. As a result the date ranges for each bar change daily. I'd like to add a card to the collection that dynamically populates the dates being pulled. For example, today the card would read something like "2016: 1/31/16-2/9/16 & 2017: 1/29/17-2/7/17". Then tomorrow the card would need to say "2016: 1/31/16-2/10/16 & 2017: 1/29/17-2/8/17." How can I make this possible?
Comments
-
Hi @juliannarenaud1. I want to make sure I understand your question correctly. Are you looking to have a new card that is only there to show the range for each year? If that is the case, would you be comfortable showing what the MTD beast modes look like? Thanks!
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Sure, here is the formula for MTD 2016 Demand:
SUM(
CASE WHEN DAY(`Date`) <= (DAY(SUBDATE(NOW(), INTERVAL 5 HOUR))+1)
AND YEAR(`Date`)+`Days to Add to Put Into Proper Fiscal YEAR` = (YEAR(SUBDATE(NOW(), INTERVAL 5 HOUR))-1)+`Days to Add to Put Into Proper Fiscal YEAR`
AND MONTH((`Date`)+`Days to Add to Put Into Proper Fiscal MONTH`) = MONTH((SUBDATE(NOW(), INTERVAL 5 HOUR))+ `Days to Add to Put Into Proper Fiscal MONTH`)
THEN `Transaction Revenue`
END)Here is the formula for MTD 2017 Demand:
SUM(
CASE WHEN YEAR(`Date`)+`Days to Add to Put Into Proper Fiscal YEAR` = (YEAR(SUBDATE(NOW(), INTERVAL 5 HOUR)))+`Days to Add to Put Into Proper Fiscal YEAR`
AND MONTH((`Date`)+`Days to Add to Put Into Proper Fiscal MONTH`) = MONTH((SUBDATE(NOW(), INTERVAL 5 HOUR))+ `Days to Add to Put Into Proper Fiscal MONTH`)
THEN `Transaction Revenue`
END)1 -
Thanks @juliannarenaud1. Have you tried creating a beast mode to identify the start and end dates and concat them together into a range and then show that in a table card?
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
No, thoughts on what that might look like?
0 -
Do you have a dataset that defines the fiscal calendar within your instance? Something that shows each day, and what fiscal month that day is in?
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Yes, it's even already connected to the GA data used to populate the cards.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive