12 Replies Latest reply: Jul 15, 2016 1:16 AM by Bharat Kishore

# Need to show top 10

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

• ###### Re: Need to show top 10

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

• ###### Re: Need to show top 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..

• ###### Re: Need to show top 10

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

• ###### Re: Need to show top 10

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

• ###### Re: Need to show top 10

Hi Bharat,

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

• ###### Re: Need to show top 10

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.

• ###### Re: Need to show top 10

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.

• ###### Re: Need to show top 10

Can you please what is the issue with the above expression and please find the attached image how  i need to display the indicators.

For example now we are displaying top 10 records.

When you sent to excel u will get values . So first thing is (individual value-avg(10 vales))/avg of 10 vales.

For example is

10,

20,

30,

40,

50

So when u take average of 5 values is 30 so that means (10-30)/30 and this is less than 10 means indicator is in red color and if it is greater than 10 means green and if it is in between means yellow color indicator.

Pls let me know if  you need thing more.

• ###### Re: Need to show top 10

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 .

• ###### Re: Need to show top 10

Thanks a lot... Thank u so much..