Dashboard Widget Chart Issue with Multi Select

I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing something? Is there a formula that I can use to pull in that single option + any combination that could be selected as part of the multi-select function?

Find more posts tagged with

Non-profit

Sheets

Formulas

Marketing

Product Development

Cell linking

Comments

Paul Newcome

Are you able to provide a screenshot of your sheet and how you want the data displayed on a dashboard? Sensitive/Confidential data can be blocked, removed, or replaced with "dummy data" if needed.

Samira

Basically, it's not showing up on my dashboard widget. It's essentially not pulling in the number from that item because it has multiple items in that one cell, it's not counting that cell since it's not an exact match. It's kind of hard to explain and I don't think a screenshot will help since I'm pulling the data from one sheet into another data sheet for my dashboard widget.

Paul Newcome

If you can share a screenshot of both of the sheets (data and metric sheets), we can help with a formula that accounts for a multi-select column. There are a lot of different ways to go with it though, so having the screenshots would really help.

If you are looking for an exact match on a combination, you would use something similar to as if it were a single-select, but if you are looking for any cell that contains that particular choice even if other choices were made with it, you would use a CONTAINS function.

A lot of it depends on your setup and use case.

Andrée Starå

Hi Samira,

I agree with Paul, Screenshots would help immensely.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Becky Hawk

I am having the same problem, I need to add the ones with 'support' all of them in order to create a graph:

Genevieve P.

Hi @Becky Hawk

Would you mind explaining a bit further? Are you wanting a total % added together for each row across the Support columns? Or are you wanting to show each Support % in a chart?

You can create Charts off of Reports, so one way to consolidate this data may be to create a Report that only shows rows where the three Support Columns contain data greater than 0. You can then create a Chart Widget from that specific Report.

If you wanted the Chart to display Summed information, you would first need to have that data somewhere on your sheet for the chart to read it, perhaps in a new Helper column that uses a formula to SUM the information in those columns for that row. Let me know if you need help creating that formula.

Cheers!

Genevieve

Paul Newcome

@Genevieve P I always forget that you can build a chart off of a report. This may end up changing a few things for me... Thanks for the reminder!!

Genevieve P.

No problem, @Paul Newcome !

The main thing to keep in mind is that it will select the entire data of the Report (you can't select sections)... so make sure your criteria in the Report Builder filter down your data to exactly what you want to see in the chart.

I also find that sometimes I have to choose the report, click on something else, then choose the report again for it to properly recognize where the data starts/ends. 🤷

Paul Newcome

@Genevieve P I am definitely going to have to play around with it. I already have a few ideas of where it may make my life easier even with having to make sure my data is exactly what I want for the chart.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.