Surplus 0s in stacked bar

by aliceoneill » Thu Jul 27, 2017 8:44 am

Hello, I've created a stacked bar chart, but I can't get rid of the 0s that appear at the top of each section - is there any way to do this?
Thanks.
Attachments
stackedbar.jpg
stackedbar.jpg (34.27 KiB) Viewed 140 times
User avatar
aliceoneill
 
Posts: 19
Joined: Mon Dec 19, 2016 10:32 am

by Nikita Kurguzov » Wed Aug 02, 2017 12:33 pm

Hello, Alice!
Sorry for the long wait, but can you please tell us more about the list you are using?
If we can get more information about it, I am sure that we can find a way to display the chart without surplus 0s.
User avatar
Nikita Kurguzov
 
Posts: 24
Joined: Fri Jul 14, 2017 1:35 pm

by aliceoneill » Fri Aug 04, 2017 2:04 pm

Hi Nikita, Thank you for replying to me.

I've got a list that contains the date someone was discharged from a ward and the ward name. I'm trying to display the number of discharges per month but show the different wards people were discharged from by stacking. So, for example, in May 2015 there were 2 discharges - one from Maple and one from Birch. This shows clearly but I just don't understand why it insists in putting a 0 in between the two coloured areas.
User avatar
aliceoneill
 
Posts: 19
Joined: Mon Dec 19, 2016 10:32 am

by Nikita Kurguzov » Fri Aug 04, 2017 2:44 pm

I can recommend using Template to filter out all the 0s. It's just a JS snippet, so it really is very simple:

Code: Select all
#= value != 0 ? value : "" #


DDNoTemplate.png
DDNoTemplate.png (18.57 KiB) Viewed 114 times

DDTemplate.png
DDTemplate.png (18.95 KiB) Viewed 114 times
User avatar
Nikita Kurguzov
 
Posts: 24
Joined: Fri Jul 14, 2017 1:35 pm

by aliceoneill » Tue Aug 08, 2017 8:55 am

That's brilliant - and so simple. Thank you.
User avatar
aliceoneill
 
Posts: 19
Joined: Mon Dec 19, 2016 10:32 am


Return to Dashboard Designer for SharePoint 2013

cron