Doubt about calculated dimenssion

[#1]

Hi i have a list of adress, but i have repeated adress, this is because i have in one adress for example 2 or 3 departments. I wanna separate this adress by departments. For example.

ADRESS DEPARTMENT

Adress 1  -

Adress 2  -

Adress 3 dep A

Adress 3 dep B

Adress 3 dep C

Adress 4 -

Adress 5 -

Adress 6 -

I'm ussing adress of dimmension but my problem is that in the count i have for example in adress 3 count=3, i tried this but it didn't work

=if (COUNT(DISTINCT ADRESS) =1, ADRESS, ADRESS& '-' & DEPARTMENT)

[Anonymous]

HI,

You should create a new filed in the script:

LOAD

....

ADRESS,

ADRESS& '-' & DEPARTMENT as AdressDepartment,

...

FROM

...

Then in the graph, you can count (distinct AdressDepartment)

[rubenmarin · Accepted solution]

Hi Jeremias, maybe is better to create the field in script, anyway for calculated dimension:

=Aggr(If(Count(TOTAL <ADRESS> DISTINCT DEPARTMENT)=1, ADRESS, ADRESS& '-' & DEPARTMENT), ADRESS, DEPARTMENT)