topic Re: How to get the data from range 5th to 10th ? in App Development

How to get the data from range 5th to 10th ?

Thu, 03 Nov 2016 10:34:33 GMT

Hi all,

I am trying to get the cities which have the total number of arrivals ranked from 5th to 10th.

This is the set analysis I have for now but seems doesn't work:

SUM({<Arrival_MonthYear={'$(=max(Arrival_MonthYear))'},[Country of Residence] = {"=Rank(sum({<[Country of Residence]=>}[Number of Arrivals]))={“<=(=25)>=(=15)”}"}>}[Number of Arrivals])

Can anyone help?

Thank you!!!

Best Regards,

Allison

Re: How to get the data from range 5th to 10th ?

sunny_talwar — Thu, 03 Nov 2016 16:37:39 GMT

May be this:

Sum({<Arrival_MonthYear={'$(=max(Arrival_MonthYear))'}, [Country of Residence] = {"=

Rank(Sum({<[Country of Residence]=>}[Number of Arrivals]) >= 5 and

Rank(Sum({<[Country of Residence]=>}[Number of Arrivals]) <= 10”}>}

[Number of Arrivals])

Re: How to get the data from range 5th to 10th ?

Fri, 04 Nov 2016 03:00:44 GMT

Hi Sunny,

Thanks for reply.

But it doesn't work.

Re: How to get the data from range 5th to 10th ?

Fri, 04 Nov 2016 05:49:08 GMT

I have got the one that works correctly just in case anyone needs it:

if(Rank(sum({<Arrival_MonthYear={'$(=max(Arrival_MonthYear))'}>}[Number of Arrivals]))>5 and Rank(sum({<Arrival_MonthYear={'$(=max(Arrival_MonthYear))'}>}[Number of Arrivals]))<10,

SUM({<Arrival_MonthYear={'$(=max(Arrival_MonthYear))'},Region={'AMERICAS'}>}[Number of Arrivals]),-1)

Re: How to get the data from range 5th to 10th ?

jonathandienst — Fri, 04 Nov 2016 06:56:49 GMT

You could use a calculated dimension of this form:

=Aggr(If(Rank(Sum(Value)) > 5 And Rank(Sum(Value)) <= 10, Dimension), Dimension)

Sum(Value) - the expression that represents the value to be ranked.

Dimension - a field (not an expression) by which the ranking should happen