Table Filter and Charts Multi Values into a graph

[Craig_Harley]

I am currently using a page properties report to return some simple parameter values

Field A - Can be Yes/No

Field B - Can be Yes/No

Field C - Can be Yes/No

Field D - Can be Yes /No

I want to be able to report on these in a single graph to show all the Yes occurrences of each field.

For example

Fields - Field A, Field B, Field C, Field D

Row 1 - Yes, Yes, No, No

Row 2 - Yes, No, No, Yes

Row 3 - No, Yes, No, No

Row 4 - Yes, No, No, No

I would want to represent these in a table/Donut chart, showing

Field A Value = 3

Field B Value = 2

Field C Value = 0

Field D Value = 1

Is there a simple way to deal with this?

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @Craig_Harley,

Please check the following example with the Table Transformer and Chart from Table macros:



SELECT "Yes" AS 'Field',
SUM(IF(T1.'Field A' = "Yes", 1, 0)) AS 'Field A',
SUM(IF(T1.'Field B' = "Yes", 1, 0)) AS 'Field B'
FROM T1



And here are the settings of the Chart from Table macro – don’t forget to set the table data orientation as horizontal:

[Craig_Harley]

Thats Brilliant, worked perfectly, thank you