chartsaway

Date data grouping does not show empty months

Recommended Posts

Hello,

 

I have an issue tracking list on sharepoint which hasn't got that many inputs from any individual category, that outputs a grouped chart displaying the count of issues by date (grouped by month).

 

Whenever a single slice of data has no entries (month with no issues), it doesn't display on the chart (eg: July will display just after May, skipping empty June), causing plenty of misinterpretation. As the data is quite seasonal, it happens frequently.

 

Is there a way to display the empty months as in the "show items with no data" option from an Excel pivot table?

 

Thanks for the help

 

 

 

Share this post


Link to post
Share on other sites

Hello,

I’m having a similar issue. I have a list as shown below: (SPData01.jpg)

 

Actual costs will be added at random times. Planned costs will have large date gaps. I’d like to show a line graph showing actual costs and planned costs. I’ve grouped by CostDate (Day) and the lines are interrupted if there is a value from the other series (Cost Type) in between the values for the other series as shown below:

 (SPDataChart01.jpg)

 

How do I get these lines to not be broken?

Thanks

Edited by MBCS

Share this post


Link to post
Share on other sites

Hi,

 

To get a connected line, you would need to use "connectNullData=1" in Other Settings > Custom Attribute section. Please refer to the attached screenshot to know how to apply this setting. You'll have to type in "connectNullData" and "1" in the respective options.

 

post-1758-0-89476100-1429005060_thumb.png

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now