Hello,
I wish to make a bar chart showing how many different Error Types make up 80% of the total errors happening to a number of different Equipment Types.
The expression I am currently using to create the bar chart is the following:
sum(Aggr(
If(Rangesum(Above(Count({1} Error_Type)/Count({1} total Error_Type),1,RowNo()))<0.8, '1',
'0'),
(Error_Type,(=Count({1} Error_Type),Desc))
))
When I choose to only show one Equipment type, it works. It simply counts how many different Error Types make up 80% of the total errors. However, when I choose to show all Equipment Types it does not work.
Do you have any idea of how to solve this?
I have attached an excel-file with my dataset and a qlikview-file with my graph as it looks now.
Thanks in advance!
