Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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