Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear ,
This is my set Expression
=count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])
for total no. of colour instances i have to show top 10 .
i used this expression
=Aggr(Rank(count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])) <=10,[Color Priority])
Its not working . Please Suggest.
@Aanchal One small suggestion.
Use a Calculated Dimension as below:
Aggr(if(Rank(count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}
[Color Priority])) <=10,[Color Priority]),[Color Priority])
And Measure would be:
count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])
If this resolves your issue, please like and accept it as a solution.
Hi ,
Thanks for the quick response .
this is not limiting to 10 .
@Aanchal Could you please send me some sample data please?
Can we not achive this by Limiting in Dimension
use formula without Rank i.e.
count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])
and limit dimension for top 10 as in above screen shot.
See the example app also
@Aanchal I concur with @SunilChauhan on restricting the display values using dimension limits.
Alternatively, maybe this
IF(RANK(Count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority]))<=10,Count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority]))
This is a measure.
its showing only 1 as output
What is the expected output?
This is desired output , but i have to display only top 10 on basis of no. of instances.
where my no. of instances is a set expression a measure
=count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])