Hello All, Here is the dataset and I would like to visualize the total distinct income generated for the distinct id’s w.r.t the site. ID status income site 123 failed 1000 Site A 123 paid 1000 Site A 456 paid 2000 Site B 678 paid 400 Site C I tried sumOver function by calculating…

Hi @sushma.sreella - Good news! We recently released a new feature that makes this easy. You can use a LAC-A function . c_sum_income_LAC-A // make income for id and site max(income,[ID, site]) Result: [image]

How to calculate total distinct income

Question & Answer

SeanBoon July 17, 2022, 4:56pm 2

Hi,

Thanks for reaching out. Reviewing previous posts here, I found this one that may work for you.

Best,
Sean

1 Like