Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table which shows the count of different ‘States’ of a defect. It looks something like this:
Instead of showing the numbers for each of the states, I want to show the percentage.
Currently I’m using the following expression:
count({$<DefState ={*}- {'Closed'}>}DefectID)
(I don’t have to show the defects which are closed)
I think the option to show the expression relatively is not available in pivot chart.
Can this be done? I hope I have made the requirement clear.
Thanks,
YASH
count({$<DefState ={*}- {'Closed'}>}DefectID)/count(Total{$<DefState ={*}- {'Closed'}>}DefectID)
Maybe this
Store the value in a variable as
var1=count({$<DefState ={*}- {'Closed'},>}DefectID)
and use in expression as
count({$<DefState ={*}- {'Closed'}>}DefectID)/$(var1)
Use NUM to show as percentage.
Regards
Pratyush
May be this
Count({$<DefState ={*}- {'Closed'}>}DefectID)/Count(TOTAL <Severity, State>{$<DefState ={*}- {'Closed'}>}DefectID)
or
Count({$<DefState ={*}- {'Closed'}>}DefectID)/Count(TOTAL <State>{$<DefState ={*}- {'Closed'}>}DefectID)
May be like this??
=(count({$<DefState -={'Closed'}>}DefectID) / count(TOTAL{$<DefState -={'Closed'}>}DefectID)) *100