How to set up dynamic date range?
I need to set up a rolling 24-month window on the X-axis such that every month, one month gets added at the end of the scale and one month is dropped off in the beginning.
For instance, in Nov 2015, the scale on the X-axis should be from Nov 2013 - Nov 2015.
In Dec 2015, the scale should automatically change and display from Dec 2013 - Dec 2015.
Could someone please tell me how to do this?
Thanks so much!
Best Answer
-
you can use the time grain at the very top of each card to do this. Make sure you use the date field you will be using for your x axis as your 'Date Range field' and then you should be able to use the time grain to do this.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1
Answers
-
you can use the time grain at the very top of each card to do this. Make sure you use the date field you will be using for your x axis as your 'Date Range field' and then you should be able to use the time grain to do this.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
Works like a charm! Thanks!
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 762 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 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