Plot data based on yes / no data

by RobertTraynor » Wed Aug 17, 2016 3:27 pm

Hi there,

I am trying to build a bar chart based on how many users have different types of software installed.

I have 4 columns which list software.

Software Item 1
Software Item 2
Software Item 3
Software Item 4

The column type in SharePoint is a Yes/No Column

But when i plot my bar chart, it shows Yes and No for all 4 columns.
I only want to see how many yes's exist for each of the 4 "Software Item" columns.

Is this something that is not possible ?

Any help would be much appreciated!

Robert Traynor
User avatar
RobertTraynor
 
Posts: 1
Joined: Wed Aug 17, 2016 3:20 pm

by Dmitry Kozlov » Thu Aug 18, 2016 2:09 pm

Create a calculated column for each of Yes/No column that returns 0 for No, and 1 for Yes. Then request those calculated columns in Data source -> SharePoint List, process data, add four series in Dashboard -> Chart, set Category to const 'Software X', and Value to sum of the appropriate calculated field.
User avatar
Dmitry Kozlov
 
Posts: 129
Joined: Wed Nov 12, 2014 3:24 pm


Return to Dashboard Designer for SharePoint 2013

cron