distinct of Sum

[Anonymous]

I am trying to find out how many distinct SUM of point each Nmae has

I am getting: Error in expression Nested aggregation not allowed  when trying : Count(DISTINCT(sum(Point)))

I tried various use of aggr but I have not yet found the solution.

Any idea?

for example for:

I would expect to see:

[vishsaggi]

You might want to use like

= Count(Aggr(Sum(DISTINCT Point), Name))

[Anil_Babu_Samineni]

May be this?

Count(Aggr(Sum(Point),Name))

[Anonymous]

does it work for you?

for me it does not, it gives 2 for A and 1 for B, should give 1 for both A and B

Thanks

[Anonymous]

no, it gives 1 and 1 in this case but also when not true

[vishsaggi]

Sorry did not check your output. I have updated the expression. LIke

= Count(Aggr(Sum(DISTINCT Point), Name))

[Anonymous]

no for example for

LOAD * INLINE [

    Name, Point, Date

    A, 2, 01/01/2018

    A, 400000, 01/01/2018

    A, 2, 02/01/2018

    A, 1, 02/01/2018

    A, 2, 05/01/2018

    A, 4, 05/01/2018

    B, 6, 01/01/2018

    B, 6, 01/01/2018

    B, 6, 02/01/2018

    B, 6, 02/01/2018

    B, 7, 05/01/2018

    B, 600000, 05/01/2018

];

also gives 1 and 1 ?

[vishsaggi]

What is your expected output for this data?

[Anonymous]

A = 3 as  over the period there were 2 distinct Sum 400002 ,3, 6

B = 2  as  over the period there were 2 distinct Sum 12 and 600007

[Anil_Babu_Samineni]

Can you show image after use this?

Count(DISTINCT Date)