In a bar chart, how can I include fields with a zero value? | XM Community
Skip to main content
Michael_Cooksey
Administrator
17 days ago
Question

In a bar chart, how can I include fields with a zero value?

C
Forum|alt.badge.img+1

I’m trying to create a table lens like display in a dashboard. But I’m hitting a snag because when I try to add a bar chart, it only displays fields with non-zero values. Anyone know how I can get around this? 

To add some detail: The three bar charts are different audiences. The bars represent the reason they indicated they visited the site. I want the bars to line up across all of the chart so it’s easy to compare why different audiences visited, but only the non-zero responses are showing. If it worked how I want, every chart would have the same dozen-ish rows (but most with zero values.) Any way around this?

Thanks!!

5 replies

J
Level 4 ●●●●
  • jbk
  • Level 4 ●●●●
  • 205 replies
  • March 21, 2025

Ensure you don’t have “Response threshold” filter in both widget level and page level. if there is, remove the filter.

C
Forum|alt.badge.img+1
  • Chassy
  • Author
  • 2 replies
  • March 21, 2025
jbk wrote:

Ensure you don’t have “Response threshold” filter in both widget level and page level. if there is, remove the filter.

Thanks ​@jbk! It’s not set, but I also can’t decrement it to 0. Is that a setting somewhere else? 

J
Level 4 ●●●●
  • jbk
  • Level 4 ●●●●
  • 205 replies
  • March 24, 2025

That cant be set as 0. Only at page level filters and widget level filters “response threshold” can be added.

 Ensure, all the fields have been mapped in the dashboard.

C
Level 4 ●●●●
Forum|alt.badge.img+16

If those options are not selected before, it wouldn’t appear in the axis.

C
Forum|alt.badge.img+1
  • Chassy
  • Author
  • 2 replies
  • March 24, 2025
Chee Heng_SZ wrote:

If those options are not selected before, it wouldn’t appear in the axis.

Thanks ​@Chee Heng_SZ! Is Display > Data Values for the widget what you’re referring to? When I turn off the filter, I see all of the possible responses as values for the axis. But when I enable the filter for a specific audience, I only see a subset. And weirdly, even when I only see the subset in Data Values, I get even fewer actually displaying. 

 

Leave a Reply


Terms & Conditions