Summary pie chart by table

[SonyaBeketova28]

 

 

Hello!

Please tell me, is it possible to make a pie chart based on the table in the first screenshot, which will summarize the indicators of all columns and the chart will show the percentage of values “1” and “0” without dividing by column headers, but taking into account all columns (as in the second screenshot)? I need a summary pie chart for the entire file

[PhanThanhSon · Accepted solution]

Hi,

Yes, that is possible using a ValueList. See figure.

The formula for the dimension is:

VALUELIST('1', '0')

You can define the formula for the measure as follows:

IF(ValueList('1', '0') = 1,
COUNT({<Measure={1}>} Measure)
+
COUNT({<Measure2={1}>} Measure2), 
COUNT({<Measure={0}>} Measure)
+
COUNT({<Measure2={0}>} Measure2))

You might need to adjust your measure accordingly, but that's the basic idea.

Otherwise just do a barchart you dont need a dimension there:

Best regards Son