Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an straight table chart. I have an expression like (sum([Unique Opens])/sum([Total Sends]-([Total Bouncebacks])))
You can see the values as in the attached image:
Now my requirement i need to show i mean highlight the values in green color which are top 3. I need to show it with an indicator.
Kindly help.
I *think* this is what you want?
Hi Bharat,
try to use in Expression: backround Color,
beck
Hi Beck,
I need to add one more expression like you know it should show with traffic signal or indicator.
can u post sample qvw
Here is a quick example using RANK in the background colour of the expression.
just adapt it to your needs by using: rank((sum([Unique Opens])/sum([Total Sends]-([Total Bouncebacks]))))
Hi Bharat,
what Kind of traffic Signal or indicator do you Need? Gauges?
beck
Hi Arul,
Please find the attached qvw.
Hi Beck,
I needed an indicator.
HI Adam,
Thanks for the qvw i have tried with your sample qvw but i am getting all in green color.
Attached qvw for your reference..
You need to use aggr and rank to solve this if you have multiple dimensions. With one this will work fine.
Have a look in the community for "top n" and you should find plenty of examples.
Searching for: Top N list with 2 dimensions
will get you a very good explanation.