Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to show in a graph the 10 largest absolute values? (indeed I have positive and negative value in my bar chart).
Thanks.
Hi Jerome,
Please check the attached app.
Try to use calculated dimension as below
=aggr(if(rank(fabs(Sum(Value)))<=10,Dimension),Dimension)
Keep the Label as "Dimension", also check the "Suppress When Value is Null" in the same properties pane for Dimension
In the "Expressions" use "Sum(Value)" with respective Label "Value"
Finally in the "Sort" properties pane, use Expression as sort order for Dimension, with the below expression
rank(fabs(Sum(Value)))
Order as Ascending
Kindly replace the Dimension and Value with your required dimension and fact values
Thanks,
Sri
Hi,
In expression use Fabs(Expression), and restrict the records, sort the chart by Expression Descending in Sort tab and by using Dimension Limits - > Show only -> Largest 10 values .
Regards,
Jagan.
Thanks for the quick answer but I was not precise enough.
Is it possible to keep showing positive/negative values on the graph but only show the 10 largest absolute values?
Hi Jerome,
Please check the attached app.
Try to use calculated dimension as below
=aggr(if(rank(fabs(Sum(Value)))<=10,Dimension),Dimension)
Keep the Label as "Dimension", also check the "Suppress When Value is Null" in the same properties pane for Dimension
In the "Expressions" use "Sum(Value)" with respective Label "Value"
Finally in the "Sort" properties pane, use Expression as sort order for Dimension, with the below expression
rank(fabs(Sum(Value)))
Order as Ascending
Kindly replace the Dimension and Value with your required dimension and fact values
Thanks,
Sri
Use Fabs(), may be something like:
Calculated dimension: =Aggr(If(Rank(Fabs(Sum(Expression))) <= 10,Customer),Customer)
Hi,
It is not possible to show positive and negative values in graph, use Fabs() to convert and use another expression without fabs() and display it as a Label by using
Chart Properties -> Expression -> Show as Popup
Regards,
Jagan.
Thanks!
Hi Jerome,
If this query is answered, kindly mark the same as answered.
Thanks,
Sri