Sum Distinct for week is not getting as expected.

Question

I have the data like left table. I am getting correct value for if I use SUM (DISTINCT Estimates) and Aggregate By ID.

But I am not getting correct data for Week. My expectation is I should get last row value of Day table for Week15 . and 04/05/2024 for Week 14.

Appreciated any help here. Attached the dva file here.

Test2.dva

Rajakumar Burra · Answer

@Subha_Tripathy-Oracle Sorry it is not as per expectation. My expectation is that by end of the week, I should be able to see actual open and closed.

A2 was closed on 04/07/2024 and again opened on 04/08/2024.

It is summing twice in open and closed. So it is giving wrong data.

Subha_Tripathy-Oracle · Answer

Hi @Rajakumar Burra

Thank you for posting in Oracle Analytics community.

I changed the calculation to SUM(Estimates). Getting correct results.

Please try this and let us know.

Thanks

Subha