Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to show top 10 records based on the Email Sent Date.
I have given the calculated dimension like this..
=if(Aggr(If(Rank(sum([Email Sent Date])) <= 6,sum([Email Sent Date])), Email_Market,Email_Brand,[Email Subject Line])
,[Email Subject Line])
But it is not fetching the latest(or) last 10 records.
Kindly suggest.
Thanks,
Bharat
I have attached the updated file below. Try by yourself in searching google, you will gain more knowledge. this will also help you to remember the scenarios in future. Good luck .
Did you mean to use Count and also say <=10?
Hi RamKumar
Please find the attached image. On how i need to get.. I am not getting latest dates.Is there anything i am doing wrong..
Not sure what you're trying to achieve. You can not sum the date field. Could you post a sample and expected output.?
Sorry. Can't see any png.
sorry.. my bad.. now pls check
Hi Nagaraj,
Pls find the attached qvw and for the market i selected Italy and Brand i selected as Fiat..Now in the e-mailsent date u can see that it starts from 6/17/2016.. Based on that i need to last 6 records.. i.e. from the names from emailsubjectline should come from 6/17/2016 to 5/5/2016.
Pls let me know if you need anything more
Hi Bharat,
In this case you can use either Dimension limit option or expression. Have a look at the attachament.
Thanks a lot Nagaraj.. My requirement is almost completed.
Now i have one more problem i.e. i need calculate the average of 6 records and i need to display in as image..
Pls find the attached excel on how i need to calculate the formula.
If the value is >10% means then green color and <10%means red and else yellow color.
If this is done my requirement is completed.Kindly help.
I am not able understand the average concept. Could you explain here.?
Note: I have modified the expression in above attachment. Please use updated one.