Chart Widget on dashboard
Hello,
I have created a report in order to create a chart widget in a dashboard, which I did, but because the variables are 2 large categories, this looks very big and it doesn't look good on the dashboard. What I would like to display on the chart widget is how many types of transactions are by location since the beginning of the year. Here is a screenshot to see what I mean. Please advise how could I better display this in the dashboard. What am I doing wrong here?
Thank you!
Answers
-
I don't know if I made my question clear, but the columns type of transaction has many different variables which are not displayed in this case. And what I would like to do is to display how many of these variables under the type of transaction we have for each country.
Your help will much appreciated. Thank you!
-
Try Adding summaries to your report, and using the Stacked column option. Sum your columns in your report will change how the Chart acts.
-
Hi Dan thank you very much for your response. That is the thing you see, I have added groups and summaries on my report and it looks like this. So not sure what to do in this case. Any other ideas?
-
Have you tried adjusting which columns are shown in the widget?
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,
Thank you for your response. I did try that actually and still doesn't display the info as I would like to.
Thank you
-
Really all you need is a single bar though. Since the locations are already listed across the horizontal axis, all you need to show is the red bar right?
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,
I tried that but when I choose to have only one column then the horizontal axis disappears. Any recommendations how could I do this in another way?
Thank you!
-
Select both columns and make sure this option is checked.
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,
I just tried that and now it looks like this. Obviously the goal is not to have all these numbers. Any ideas what goes wrong here?
Thank you.
-
You should only have the column that contains the location and the column that contains the number of transactions. Are you able to provide a screenshot of 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!
-
Hi Paul,
Thank you so much fo your support on this. Please see below a picture of how my report looks like.
Looking forward to hearing from you.
Thank you!
-
Your locations should be listed in the Primary Column. Then you would include the Primary Column and the Type of Transaction column for your chart widget.
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'm afraid I can't move the location to primary as the information in the report come from another sheet where the primary column is something else.
Is there any other way to display on a chart widget the information as it looks in the report? (ex: for Buenos Aires we have 3 new hires etc)
-
You would need to create a separate metrics sheet, list the locations out, then use cross sheet references in formulas such as COUNTIFS to output the counts.
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
Thank you for your suggestions, but I'm not quite sure why do I need to use other sheets? If you think this is the best way to do it, how could I list the locations in a way to take the info from my main sheet and display how many new hires etc we have in each location?
Thank you
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives