Formatting Week Number Display
I have a use case where I need to show charts by Week Number formatted as "W1-19" vs the Domo default of "Week - 1 2019", while retaining the functioniliy of the dimension as a Date type. Does anyone know if it's possible to modify the date format for week number?
Thank you!
Comments
-
Hi
You can achieve it by below calculation-
CONCAT('W',WEEK(`DATE`), '-',YEAR(`DATE`))
0 -
Unfortunately the concat function returns a data type of string therefore the date dimension is lost. You would lose hte ability to change the by data dimension.
0 -
I agree but you can still use them in charts and it works fine and plots data correctly to the correct week.
Do you want to share whats the purpose of keeping the date data type intact so we can think of some other alternate solution?
0 -
You could also use DATE_FORMAT()
DATE_FORMAT(`Date of Invoice`,'W%V-%y')
But that will also result in a text field. It does not look like the chart properties supports the week outputs:
This might be something that should be an idea suggestion.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive