Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sum Distinct for week is not getting as expected.

Received Response
42
Views
2
Comments
Rajakumar Burra
Rajakumar Burra Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

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
image.png

Answers

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Mod

    Hi @Rajakumar Burra

    Thank you for posting in Oracle Analytics community.

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

    image.png image.png

    Please try this and let us know.

    Thanks
    Subha

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    @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.