Charting with dates using the data on the Report Item
The labels for my date are weird. How do I fix?
The information under each Due dates are file names.
...
Answers
-
Try switching the columns in the source.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I can switch the series in the Dashboard, but cannot switch in the source since its a Report item.
...
-
You should be able to rearrange the columns in the report.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That wont work, the report is attached to a pre formatted sheet. Position of the data arent the issue, its the label. Its showing these numbers instead of dates.
...
-
Moving columns in a report does not affect the data they show or the data in the sheet.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
-
I understand that updates in CELLS in the report will update the sheet, but moving columns in the report will not affect the source sheet(s) at all.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
did you mean to move them side by side? alright I moved them next to each other, re create another Chart and still giving me the same info (btw we updated the dates)
source:
report:
chart:
...
-
Try putting the dates on the left.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
-
There should be an option in the widget settings to use the first column as data labels. Do you have that turned on?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
yes, i did those. the issue is the label.. it showing these large numbers.
...
-
@Genevieve P. @Andrée Starå Do either of you have any insight into this?
If you group a report by date then try to chart it, your labels will be some crazy long numbers that I am not sure where they are even coming from. I can confirm that I have been able to replicate this. I have tried messing with every setting I can thing of to no avail.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi @Paul Newcome and @heyjay
No, I haven't seen this before. @heyjay, if you haven't done so already, please contact our Support team (here) with screen captures and steps you took (aka. Grouped by Date, then used this as the source for your chart) so that we can properly investigate this and determine the cause.
Thank you!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thanks for the feedback @Genevieve P.. I will also submit a ticket and will try to remember to update this thread once I find something out.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives