Nesting Bar Chart not showing totals after filter

Hello,

I've created a nesting bar chart and it shows the totals when I have all the data selected, however when I try to filter down to a specific format, the totals go away even though there are markets and stations still in there. Any filtering removes a total and I would like totals implemented. Any advice?

Find more posts tagged with

Accepted answers

GrantSmith

Hi @user031517

When you filter your data you're telling Domo to ignore your other data rows so when it goes to plot your single filtered rows and has no context of your other rows / totals so you only have a single value which is your total value as well.

Instead of filtering you can still plot the data and keep the context but hide the visualization of the data by clicking on the elements in the legend. It will hide them but should still display your overall total.

All comments

GrantSmith

Hi @user031517

user031517

That helps, but is there a way to keep the total with filters at all? We filter on actually many different variables and not just the one.

GrantSmith

No because the filter happens before the data is displayed so it's not there to show the totals since your card doesn't know about those rows.

user031517

Understood, thank you.

jaeW_at_Onyx

as @GrantSmith when you apply filters it sets the context for what data is available as you calculate the denominator in the percent of total calculation.

there is a new beta feature in development that will allow one visualization to support 'filter groups'. the title of the feature may have changed, but the gist of the idea is that you can define a filter group that will not respond to certain filters. so for example if you set a group "South West" and then you filtered where State = "Arizona" (which is in the South West), the South West group would include all states in the SW.

Ask your CSM for more information about the beta program, this feature may help you accomplish your visualzation requirement.

@GrantSmith -- do you remember off top what hte feature was called?

GrantSmith

I don't but I'm sure the CSM can help translate the request to the beta feature.

user031517

Thanks, I will contact our CSM

MarkSnodgrass

I think you are referring to Filter Views that is in Beta right now, but you could be referring to something else.