Charting "top 10" using report?

Dan Tanner

Hey guys,

I'm creating a dashboard right now for my team. I want to be able to chart some data in either a bar graph or pie chart. I want to limit this to just a top 10. I was hoping to do this by a report but I don't think i'm able to. Here is a bit more info:

Report pulls in data from 17 sheets (17 different users, sheets are the same)

The column data that I want to chart has about 50-60 different options, and I want to chart the top 10 options that are highest value (tracks sales of a vendor)

I COULD do a rank EQ in a helper sheet that pulls in everything, but I think that would take a really long time with all the formulas and sheets that would be needed. I think I could use AI but it'd still take a long time.

Let me know your thoughts. I really wish there was a way to just have this option when creating a graph on Dashboard.

Thanks,

Darren Mullen

@Dan Tanner Your assessment is correct from what you described.

Do you have access to DataMesh or Smartsheet Bridge? If so, you could bring the report data into a sheet (assuming it doesn't exceed sheet cell limits)

Then you could get your top 10 from there.

If you don't have DataMesh or Bridge and need an alternative report to sheet option, we have that too :) https://smartsheetguru.com/smartsheet-report-to-sheet/

Dan Tanner

@Darren Mullen Thanks so much for your quick reply. I do have access to Datamesh, though I've never used it. If you it doesn't take too much time I'd love to learn, or if there's a Youtube video that could get me started

Darren Mullen

@Dan Tanner With DataMesh you can send data from a Report to a sheet generally. Does each row have a unique identifier?

I ran a Guru Elite session on this. I'll see if I have time to sanitize part of that video for public consumption.

Dan Tanner

@Darren Mullen Would be great if there was a condensed version. I tried to do a report to datamesh and it only pulled one line vs the consolidated total.