Need to show top 10

[bharatkishore]

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

[#2]

Did you mean to use Count and also say <=10?

[bharatkishore]

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..

[tamilarasu]

Not sure what you're trying to achieve. You can not sum the date field. Could you post a sample and expected output.?

[#5]

Sorry. Can't see any png.

[bharatkishore]

sorry.. my bad.. now pls check

[bharatkishore]

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

[tamilarasu]

Hi Bharat,

In this case you can use either Dimension limit option or expression. Have a look at the attachament.

[bharatkishore]

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.

[tamilarasu]

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.