Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using a line chart with 2 dimensions ,Primary dimension being the 'Date' figure and secondary dimension is a general field (Ex- Engineers).
Requirement is to restrict Engineers to 'TOP 10' among the entire data which in the chart is showing improper values.
Being the secondary dimension Different Top 10 values are coming for each Date value(Primary Dimension).
How to restrict this issue to only secondary dimension with top10 values in entire data and not on each date values. ??
Try using a calculated second dimension like
=aggr( if( Rank(Sum(Value),4,0)<=10, Engineer), Engineer)
See also attached a sample QVW.
edit: Corrected a typo
Try using a calculated second dimension like
=aggr( if( Rank(Sum(Value),4,0)<=10, Engineer), Engineer)
See also attached a sample QVW.
edit: Corrected a typo
Thanx for your help .
Its working