Plot data based on yes / no data

Dashboard Designer SharePoint 2013/2016, Office 365 versions
1

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

2

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.