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?
-
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?
-
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.
-
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?
-
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.
-
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.
-
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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives