Jump to content
  • 0

Chart to display zero count


TMeyer
 Share

Question

I have a chart that is filtered by a submission page passing virtual parameters. Depending on the parameters, the 'count' may be zero for a certain value. Is there a way to display a count of zero on a bar chart (or any type of chart for that matter)? 

 

When the chart automatically adjust to the number of bars displayed it messes up their width, size and color scheme. I want the colors representing the people to stay the same, not change just because a person who is usually represented in the middle of the bar chart has a count of zero for that chart.

 

 

dashboard1 partial.png

dasboard1 full.png

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0
On 1/8/2017 at 4:50 AM, TMeyer said:

I have a chart that is filtered by a submission page passing virtual parameters. Depending on the parameters, the 'count' may be zero for a certain value. Is there a way to display a count of zero on a bar chart (or any type of chart for that matter)? 

 

When the chart automatically adjust to the number of bars displayed it messes up their width, size and color scheme. I want the colors representing the people to stay the same, not change just because a person who is usually represented in the middle of the bar chart has a count of zero for that chart.

 

 

dashboard1 partial.png

dasboard1 full.png

I would recommend selecting the  same field with is used for "Value" for the "default sort order" setting. This setting can be found on the last screen of the chart wizard. Please note, you need to select a field with aggregation, e.g. Count(field_name)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...