Dimension Limits

[#1]

Hy,

It is possible to put a condition like "Show only values that accumulate ​​from X to Y". Can you suggest a method to do this?

Thank You!

[#2]

Use set analysis, not dimension limits tab.

[Anonymous]

Dincovici

I am don't really understand the details what you are precisely trying to achieve, but have you tried looking at the Chart object "Dimension Limit tab ?

If that is an irrelevant to your question then please clarify what you are after ?

Best Regards,     Bill

[#4]

Yes Bill, I tried to use "dimension limits", but there I can not enter an interval. For example, I need to take values ​​that are between 80% and 90% relative to the total, using largest values.

[Anonymous]

Dincovici

As Thomas suggested Set Analysis could well be the way to go.

Or maybe you could try a Calculated Dimension with an if... blah, blah, blah.  But beware as injudicious use of Calculated Dimensions can cause performance issues.

If could you post some sample data it would make understanding your requirement a lot easier.

Also additions to the load script can often help things like this.

Best Regards,  Bill 

[#6]

My load script is similar to:

Sellers:

LOAD

  Bids_SellerId,

  Bids_CatalogId,

  Bids_State,

  Bids_InShop,

  Bids_Regdate,

  Count(Bids_Id) as Bids_Count,

  Sum(Bids_CurrbId) as Bids_Value

Resident

  Bids

Group By

  Bids_SellerId,

  Bids_CatalogId,

  Bids_State,

  Bids_InShop,

  Bids_Regdate;

I tried to create a straight table, with  Bids_SellerId as dimension, ordered descending by sum (Bids_Value). Now I have to find a solution to extract a list of sellers who made between 80% and 90% of total revenue. I tried to create a dimension based on rangesum but it crashes (Error in calculated dimension). Something like:

If(RangeSum(Above(Sum(Bids_Value),0, RowNo())) > vLimit1 and RangeSum(Above(Vanzari,0, RowNo())) < vLimit2, 1, 2)

Probably I'm not allowed to use RangeSum in calculating dimensions...

The same formula used as an expression works fine, but it crashes when the dataset exceeds 100,000 records. Also used as an expression does not help me too much because I can not make a selection based on it