Forum Discussion

FlowViz's avatar
FlowViz
Icon for Helper III rankHelper III
4 years ago
Solved

Help calculating timestamp differences

Hi folks,   I have a table like so:     I'm trying to calculate a couple of things: 1) How would I calculate the total time in each ColumnName for each WorkItemId? For example for WorkIt...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

How did you arrive at the answers of 7,0,63 and 5?

  • FlowViz's avatar
    FlowViz
    Icon for Helper III rankHelper III
    4 years ago

    For example, the 63 calculation is for when the item went into ColumnName of 'In Progress' on 10/17/2021 and then went into ColumnName of 'In Build' on 12/19/2021, meaning it was in 'In Progress' for 63 days...

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      You may download my PBI file from here.

      Hope this helps.

      • FlowViz's avatar
        FlowViz
        Icon for Helper III rankHelper III
        4 years ago

        Thank you!