Limiting Dimension

[#1]

Hi All,

I have a field that I would like to use as a dimension, but I do not want to use all the unique values in this field, just some of the values. The values I would like to extract as forming the dimension are based on another column eg if Field A says "Agent", then use the corresponding value in Field B as one of the dimensions, otherwise that Iitem in Field B should not be part of the dimensions.

Is this possible, and if so, any ideas on how I can pull this off?

Thanks

H

[its_anandrjs]

Provide any sample file please in any inline table than it will easy to help, or yo can use if conditions in the load script.

Regards

Anand

[danieloberbilli]

Maybe something like:

load

FieldB as DimensionNew

resident xyz

where FieldA ='Agent'

or FieldA =...

or ....

[ecolomer]

Can you explain more or upload an data example, please

[#5]

Something like:

if(FieldA='Agent' and Match(FieldB,'Agent'),FieldA, FieldB)

Thanks,

Singh

[jonathandienst · Accepted solution]

Hi

Use the following as a calculated dimension:

=Aggr(Only({<FieldA = {'Agent'}>} FieldB), FieldB)

HTH

Jonathan

[#7]

Thanks Jonathan,

Your answer has provided the closest result. The only snag is that the values that are not "Agent" have been bundled into one line called "-" as a dimension, how do I get rid of this line (straight table) so that I am left with purely the list from Field B that corresponds with "Agent" in Field A.

Otherwise your suggestion is very very close.

Thanks

H

[danieloberbilli]

Just check the checkbox Suppress When Value is Null on the dimension tab of the chart properties

[#9]

Thank you guys