Hi,
I have the attached dataset and I’m trying to figure out to sum the values of:
maximum on metric1 partition by c1 .
The upper should be partition by c2.
In the data sample below, A1, will get 11000 and B will get 12000.
I tried sum(maxOver(metric, c2)) and it didn’t work. ant ideas?
| c1 | c2 | metric |
|---|---|---|
| A | D | 9000 |
| A | D | 9000 |
| A | E | 2000 |
| A | E | 2000 |
| B | F | 5000 |
| B | F | 5000 |
| B | F | 5000 |
| B | G | 7000 |
Hello @amico - Thank you for posting your query. I have tried to replicate the scenario at my end and I believe you need to create a calculated field using the following expression to achieve what you are looking for.
Can you please try this at your end and let me know if that works. Sharing you the snapshot of the output that I have got at my end based on the example dataset that you have provided in the post. Hope this helps!
Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!
this helps!