Show only some data in graph

[#1]

Hi,  

I have a graph with:

- dimension : Person

- espression: SUM(measuse)

I want to show in my table only Person that have SUM(measure) over a certain amout.

You know how to do that?

thank u!

[MK_QSL]

Like this?

UPDATE FILE ENCLOSED...

[Colin-Albert]

The dimension Limits tab will allow you to do that based on the first chart expression.

Select "Show values that are Greater than..,."

this can be an absolute amount or a percentage.

[its_anandrjs · Accepted solution]

Hi,

In Dimension

dimension : Person

and in

expression:  =if( SUM(measuse) >= 200, SUM(measuse),0 )

Thanks & Regards

[its_anandrjs]

Hi,

Yes you can use Dimension Limits option also like largest, smallest greater less and in % also

Thanks & Regards

[#6]

Your other answer works

but i would like to ask: how can I do that in "Dimension Limit"? "Dimension Limit" can limit the dimension, not the expression/measure.... Am I wrong?

[MK_QSL]

Try...

Calculated Dimension

IF(Aggr(SUM(measure),Person)>=200,Person

Tick Suppress When Value is NULL

Expression = SUM(measure)

[MK_QSL]

You can also use as below

Create a straight Table

Dimension = Person

Expression = SUM({<Person = {"=SUM(measure)>=200"}>}measure)

Please note that for large data set, Calculated Dimension will slow down your apps but above set analysis gives better performance

[its_anandrjs]

Hi,

Yes you are right the option limits the dimension according to your choice and it depends on which type of the dimension you are using it is text, number and date. But by dimension if you want to control limit you have to identify in which criteria the expression comes and manage.

Hope this helps

Thanks & Regards

[Colin-Albert]

Dimension limits will restrict the chart to only show dimensions where the expression meets the limit defined.

Given the original question, adding a dimension limit will apply the restriction on Person, based on the first expression sum(measure) .

So dimension limits will give the result that was asked for without the need to add any other "if" statements or set analysis.