Forum Discussion

anonymous1124's avatar
anonymous1124
Frequent Visitor
3 years ago

Showing continuous date till current date (TODAY)

I have a code that counts daily counts of new defects as of current date and refreshes everyday. If there are 0 new defects it will reflect 0. I have also set a filter to plot a graph within a week, so example, 28 june 2023 (today) I have zero defects, thus from 22 june 2023 to 28 june 2023 I should have 0 defects plotted on the graph. 

 

However, not all dates were shown on the graph, hereby is my code, do you guys have idea on how to solve this? 

missing: 22,23,24 june 2023 that will reflect onthe graph.

Thank you.

Need Help
Tutorial Requests

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi anonymous1124 

     

    Try this measure instead:

     

    Daily Count of Open Defects 2 =
CALCULATE(
    COUNTBLANK('Overall Rail & 3R'[Defect Status]),
    'Overall Rail & 3R'[Date Found] = TODAY()
) + 0

     

     

    Also, not sure how you're getting a week's worth of history when you're filtering your data against TODAY(), but probably beyond scope at this point.

     

    Pete