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.