Limit Dimensions

[#1]

How to choose the first 5-10 dimention in a bar chart?

Say it has 20 dimentions, I want the 5th-10th ones. Is there any way to do it?

Thank you.

[Anonymous]

U mean the 20 dimension fields or 20 values for a single dimension? explain more clearly.

[ashfaq_haseeb]

Hi,

Based on what criteria you need to filter this?

Regards

ASHFAQ

[jyothish8807]

Hi Anna,

Is there any criteria on which the dimension is sorted?

like assending order or descending sum(sales) or anything like this?

A screenshot will be helpful.

Regards

KC

[kuba_michalik]

Easiest way would be to enable X-Axis scrolling when number of items exceed 6 (under Presentation tab), and let the users scroll themselves until only positions 5-10 are shown 😉

If you want to hard-limit the display to only those positions, it's more complicated.

[Anonymous]

U can use Calculated Dimension like this:

Here Product is the Dimension

and based on sum(price) i m ranking the product and taking only the dimension values falling between rank 5 to 10

=if(aggr(rank(sum(price)),Product) >= 5 and aggr(rank(sum(price)),Product) <= 10 ,Product)

[Anonymous]

One way of doing this is through a calculated dimension where you use a combination of AGGR and RANK.

E.g.

=IF(

  AGGR(RANK(SUM(Amount),4),Dimension)>=5 AND AGGR(RANK(SUM(Amount),4),Dimension)<=10 ,

  Dimension

  )

See attached example.

Kind regards

Niklas

[#8]

I mean the dimension fields for a single dimension.

Just want Jan-14 to Sep-14.

[Anonymous]

Ya u can achieve this in multiple ways:

1. When i see the chart,it seems the other dimension values are having null values- just go to Presentation tab enable the Suppress the null and Suppress the zero values options.

[jyothish8807]

Hi Anna,

What is there in expression?

Iam asuming it is  sum(Turnover Postponed)

Then try like this in expression:

sum({Date={'>= Jan-14 <= Sep-14'}>}[Turnover Postponed])

sum({Date={'>= Jan-14 <= Sep-14'}>}[Customer Serivce rate])

Regards

KC