Chart Widget on dashboard

Christiana Gkini

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!

Christiana Gkini

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

Try Adding summaries to your report, and using the Stacked column option. Sum your columns in your report will change how the Chart acts.

Christiana Gkini

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

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

Christiana Gkini

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

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?

Christiana Gkini

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

Select both columns and make sure this option is checked.

Christiana Gkini

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

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?

Christiana Gkini

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

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.

Christiana Gkini

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

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.

Christiana Gkini

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