How to calculate total distinct income

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 the sum(income) over ID and site but I wanted the distinct income.

So I calculated sumOver(max(income),[id,site]) but I also need to calculate the sum of total income for different sites month wise. Can anyone help me with this.

Thank you!!


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


1 Like

Hi @sushma.sreella -

Good news! We recently released a new feature that makes this easy. You can use a LAC-A function.


// make income for id and site
max(income,[ID, site])