Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
I have errors (e.g. F1, F2) and error types( T1,T3 for error F1) (see attached qvw).
I'm trying to show the top X errortypes per error in a trellis chart.
Can someone tell me how to implement this (At the moment I get all types for each errror?
Thanks in advance.
Kind regards
Aloah
I found other related post with the same problem and no solution. So I think I have to set this up with separate bar charts.
Can someone help me how the formula must look like to get top 10 error types per error. Thanks in advance.
Tried with a dynamic dimension: =if(rank(aggr( sum( Amount ), Error ))=1, Type) for top 1 error and related types
but this is unfortunately not working
Aloah