Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Line chart with item status

Hello all,   I hope you can help me. I would like to have a line chart that shows the status of an item. An item can be open or closed. Open items can be overdue. My fact table looks like the one b...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

What's the calculation for the "number of open items" and "number of open items that are overdue"? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Ashish_Mathur , thank you for you message.


    # of Open Items = # ItemNo where ItemTable[CloseDate] > Calendar[Date]

    # of Overdue Items = # Open Items where ItemTable[DueDate] < Calendar[Date]

     

    Kind regards