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
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 464 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive