topic Re: Problem with expression in Connectivity & Data Prep

Problem with expression

mtabernad — Wed, 07 Jul 2021 13:18:19 GMT

Hi,

I am trying to create a dynamic table with two dimensions: "year_month" and "Group client version" and one metric:

Count({<Month={'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'},Type={'av'}>}distinct asset_nm&site_nm)

Could anyone tell me why the total value for May (3,555) for example (but it happens with all the months) does not match with the sum of values for v12 (310) and v14 (3,249)?

Thank you in advance.

Re: Problem with expression

Kushal_Chawda — Wed, 07 Jul 2021 13:46:21 GMT

@mtabernad try below

=if(Dimensionality()=1,

sum(aggr( Count({<Month={'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'},Type={'av'}>}distinct asset_nm&site_nm),yearmonth,[Group client version])),

Count({<Month={'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'},Type={'av'}>}distinct asset_nm&site_nm))

Re: Problem with expression

mtabernad — Wed, 07 Jul 2021 15:26:11 GMT

Hi Kush,

Thank you for your comment. Still does not work and total sum shows 0:

Re: Problem with expression

Kushal_Chawda — Wed, 07 Jul 2021 15:29:55 GMT

Make sure that field names are correct in Aggr. Also how many dimensions are there in pivot?

Re: Problem with expression

mtabernad — Wed, 07 Jul 2021 15:40:31 GMT

Initially there were 4 dimensions but I deleted 2 of them to make the problem easier.

Dim1:

Dim2:

Metric:

Pivot table: