This content has been marked as final.
Show 2 replies
-
1. Re: How to calculate the score of string values for a given period
Prayson Wilfred Daniel May 2, 2017 11:59 PM (in response to Anuj Vaijapurkar)1 of 1 people found this helpfulHej Anuj,
Were I you, I would create a score for my PromoType as:
{ FIXED [Year]: SUM(IIF([PromoType]='PROMO1',1,0))}*100/{FIXED [Year]: COUNT([PromoType])}
With all my score in order:
From there you can build the bar chart and filter top 5 given their ranks.
-
2. Re: How to calculate the score of string values for a given period
Anuj Vaijapurkar May 3, 2017 12:03 AM (in response to Prayson Wilfred Daniel)Many thanks, Prayson! That worked for me!