-
Re: limiting and ranking data on a simple table based on a dimension and a measure
If I fully understand:
1) in ur table, put one dimension as follow:
=aggr(if(rank(DCIPU ,-DCIPU )<=10, DCIPU ),DCIPU )
and uncheck show null values
2) dim1:
dim2: =aggr(if(rank(DCIPU ,-DCIPU )<=10, DCIPU ),MFG,DCIPU )
and uncheck show null values
result (per analogy)
-
Re: limiting and ranking data on a simple table based on a dimension and a measure
Omar, what does the Rank(something,-something) do?
-
Re: limiting and ranking data on a simple table based on a dimension and a measure
Hi Omar,
the 2 expressions work but have a common problem as the remainder of the rows appear on the table with a '-' symbol in place of a value for example if I was to show the top 2 the following is showing, and it continues for the remaining 397 rows
MFG DCIPU WMS 1000 BALLY 900 IGT - and I unchecked show the null values. Am I missing a step?
-
Re: limiting and ranking data on a simple table based on a dimension and a measure
Hi Omar,
The solution works, The was an extra step I didn't know about which was going to the Add-ons tab and unchecking the 'include zero values' box. Thanks for your help
-
-
Re: limiting and ranking data on a simple table based on a dimension and a measure
Maybe this will help you:
SUM({<YOUR_DIMENSION={"=RANK(SUM(YOUR_MEASURE))<=10"}>} YOUR_MEASURE)
or
Only({<YOUR_DIMENSION={'=rank(sum(YOUR_MEASURE))<=10'}>}YOUR_DIMENSION)
Cheers
-
Re: limiting and ranking data on a simple table based on a dimension and a measure
that won't do it thiago :
try my expressions and urs with this inline table, u'll see what happens in each case:
load * Inline [
dim, mesure
1, 200
1, 300
1, 400
1, 500
1, 600
2,300
2,400
2,500
2,600
2,700
a,500
a,600
a,700
a,800
a,900
a,100
b,600
b,700
b,400
b,300
b,900
];
-
Re: limiting and ranking data on a simple table based on a dimension and a measure
You're absolutelly right! My mistake...
-
-
