Aggr concat with count

[beck_bakytbek]

Hi Folks, i got the following issue, my data-environment does look like:

ID, Values,

1, 2

1, 4

1, 5

2, 4

2, 6

on the UI within the Expression - Editor  i am using this Expression:

Aggr(concat(distinct Values, ' , '),ID)  then i have the following structure:

ID, Value

1,  (2, 4, 5)

2, (4, 6)

the above Expression does work great. my Question is:

how can i show the following strukture:

ID, Value

1, 3 (because id =1 has total3 values)

2, 2 (because id = 2 has total 2 value)

i was trying to solve it by using the following Expression: aggr(concat (Count(Values), ' , '), ID) but i did not achieve the expected result.

Does anybody have any idea how to solve the above issue in script-area and on UI (Expression editor)?

Thanks a lot in advance

Beck

[sunny_talwar]

Just use Count(Value)

[mfarsln]

Hi,

Try this;

Count(distinct total <ID > Values)

[sunny_talwar]

That seems very complicated if ID is the only dimension....

[mfarsln]

H Sunny,

Yea you are right. I thought there would be another dimensions too.

[beck_bakytbek]

Hi Mfarsin,

thanks a lot your time and Suggestion, i know this Expression, but i would like to know, how to solve this issue in script-area or UI

Thanks a lot

[beck_bakytbek]

Hi Sunny, thanks a lot for your time and Suggestion.

if you have any idea how to solve this issue, please let me know

Thanks a lot

[sunny_talwar]

Count(Value) as a measure should resolve your problem