Date is changing from M/D/Y to the number week in the year.
I have a grouped and stacked card that is showing revenue for the last 3 weeks. I have the date filter set up to show last 3 weeks filtered by week. However, the data format is showing the number of weeks in the year instead of the week start date that is in the actual data. My column 'Week Start Date' has Sunday dates on it and I'd like the bar to show that instead of Week 38.
Details:
Week Start Date - 9/2/18 and 9/9/18
Showing: Week 36 and Week 37
Thanks for the help.
Best Answer
-
If there is no data and dates are showing you should change CHART PROPERTIES --> CATEGORY SCALE (X) --> NEVER USE TIME SCALE to 'True'
This should remove dates without values
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Answers
-
Hi Jeremy,
You should just be able to change the "Graph by" to "None" and it should show your actual dates.
Thanks,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
I did try that as well thinking that may solve my issue but then I see all the dates. I'd like it to just show the two dates with the amount of revenue for the week and not the whole month.
0 -
So your date range says last 3 weeks and it's graphed by none but you are seeing more than three weeks?
Can you send a screenshot of your example?
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
If there is no data and dates are showing you should change CHART PROPERTIES --> CATEGORY SCALE (X) --> NEVER USE TIME SCALE to 'True'
This should remove dates without values
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1 -
This worked. I misread that and applied false but true cleared it up. Thanks for the help.
1 -
In order to get week over week you have to graph by week. The only problem it shows the week numbers like it was stated. If I select graph by none, then no data appears - I also enabled the setting to True.
Any idea why it's not working.... thinking it's not possible with week.
See screenshot below0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive