Forum Discussion

KG1's avatar
KG1
Icon for Resolver I rankResolver I
2 years ago

Completed and Outstanding ID's

Hi Hoping someone very clever out there can help me 😊   The structure of my data is as follows I need to be able to track the total number of outstanding ID's at the end of the day   The...
Need Help
AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
2 years ago

Can you please provide some textual data and a clear example ?

  • KG1's avatar
    KG1
    Icon for Resolver I rankResolver I
    2 years ago

    This is how my data is structured to work from 

     

    ReceivedRegistered1st Stage Approvedsecond stage approved3rd Stage Approved
    01/07/202406/07/202412/07/202427/07/202419/08/2024
    03/04/202408/04/202414/04/2024  
    15/08/2023    
    14/07/202319/07/202325/07/202309/08/202301/09/2023
    08/06/202413/06/202419/06/202404/07/202427/07/2024
    23/05/202328/05/2023   
    12/04/202417/04/202423/04/202408/05/202431/05/2024

     

    This is an example of the output table required

     

    DateYTD TotalNo Received (daily)Total Registered (daily)Total 1st Stage ApprovedTotal second stage approvedTotal 3rd Stage ApprovedTotal O/S
    12/07/202470050677782501
    11/07/202465056687578503
    10/07/2024645545215654581
    09/07/2024640 215215635