Sum without duplicate values with conditional values

Q&A
, ,
1

Dear Team ,

I want to do sum value without duplicate with If or Conditional Statements.
Please let me know.

Regars,
ThawZin

2

can elaborate more on the use case and an example showing what you want to achieve?

We have functions for aggregation. Do you think this can help?

3

There is duplicate record with same date , same type and same value.
I just need unique sum without duplicate sum.

Sample Dataset
Date Type Status Price
10-Aug-24 A yes 100
10-Aug-24 A No 100
10-Aug-24 A yes 100
10-Aug-24 B yes 100
10-Aug-24 B No 100
10-Aug-24 B yes 100
Result 1 _ CalTypeA
Condition IF Type =A , Status =yes
10-Aug-24 A yes 100
Result 2_CalTypeB
Condition IF Type=B , Status=yes
10-Aug-24 B yes 100

I want to put those kinds of two results on Table Chart AS WELL.
table design is Group By - Date , Value - Result 1 , Result 2

image
image696×561 10.9 KB

4

  1. you can use calculated field to put ifElse condition like this ifelse(Type="A" and Status='yes', Price, 0)
    image

  2. Use Avg for the new created calculated field

  3. Create a filter to include Status = Yes only

image
image561×658 33.7 KB

5

Thank , but I don’t need duplicate values because there are same date, same type, same status . Unique key should be Type , let Type A be unique key

6

I got the solutions like that

sum(
ifelse(Type= ‘A’,
maxOver(price, [A, Status], PRE_AGG)/countOver(Type, [Type, Status,date], PRE_AGG),
0)
)