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!


Tags:
«13

Answers

  • Christiana Gkini
    edited 05/19/22

    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!

  • Dan W
    Dan W ✭✭✭

    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?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Have you tried adjusting which columns are shown in the widget?

    thinkspi.com

  • 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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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?

    thinkspi.com

  • 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!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Select both columns and make sure this option is checked.



    thinkspi.com

  • 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.


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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?

    thinkspi.com

  • 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!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.

    thinkspi.com

  • 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)


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.

    thinkspi.com

  • 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