Forum Discussion

MattBussard's avatar
MattBussard
New Member
3 years ago

Real time reporting based on current time

Hi all, I'm a new member who's learning power bi to use in a corporate environment for defect and KPI reporting.

 

I've searched around and have been unable to find a suitable answer to my issue.

I've created a real time dashboard that shows production information for the current shift such as downtime, rework charges, and defect types that have been reworked. I've trimmed it down to relevant data by using WHERE DEFECTDATE > TRUNC(SYSDATE)+7/24 so that it displays the current shift's information. Now comes the hard part (for me). I have to implement the night shift. We have 2 shifts which are 7am-7pm, and 7pm-7am. I need the information displayed on my report to display based on the current time, so if it is 2am it would display the information for the 7pm-7am shift and so on. Since this report refreshed automatically every minute, I'd like to manage this in the query itself so that only relevant data is being pulled from the oracle database I'm querying. Is there a way to do this on the SQL level? If not, I'm open to suggestions, of course I could add a custom column to identify the shift and use a splicer, but I'd prefer it to be automatic for the user. I'm open to any suggestions.

 

Thank you!

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    MattBussard , Based on what I got you have now in pwoer bi

     

    You can measure, that you can use in visual or visual level filter

     

    calculate(sum(Table[Value]) , filter(Table, Table[Created date] >= now() -1)) //-1 days

     

    you can subtract time using time

    now() - time(5,0,0)