Have date range in x axis for week
Hi
I have a weekly data and I want to represent date(x axis) as Jan "1-7" instead of "week 1" .
Is this possible to do so in for a set of cards instead of changing this feature at an admin level?
Thanks
Chetan
Best Answer
-
@chetan_cricut You would need to create a calculated field to concatenate the first and last day of the week (similar to how you created the week start date) for your x-axis, sorting by week start date. Your x-axis calculation would look something like this:
concat(date_format(`Date` - dayofweek(`Date`) + 1,'%b %d), ' - ', date_format(`Date` + (7 - dayofweek(`Date`)),'%b %d))
3
Answers
-
Hello,
I think you are asking about field formatting, just click on the date field when that expands all the way at the bottom is the "Date Format" checkbox you can change it to what you want the card to use.
Hope this helps.
0 -
Sorry, I dont see that. Can you please share a snippet.
0 -
@chetan_cricut If you would rather manage this at the card level, then add a week start date field to the x-axis and set the date graph by setting to "none".
1 -
@MichelleH I already did that, but I would rather want to show the date range instead of start/end of week. Do you know of a work around here?
0 -
@chetan_cricut You would need to create a calculated field to concatenate the first and last day of the week (similar to how you created the week start date) for your x-axis, sorting by week start date. Your x-axis calculation would look something like this:
concat(date_format(`Date` - dayofweek(`Date`) + 1,'%b %d), ' - ', date_format(`Date` + (7 - dayofweek(`Date`)),'%b %d))
3 -
@MichelleH Thanks, that worked!!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 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