Forum Discussion

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

Help with query across tables

Hi Guys,   I have a Jira dataset structured like so (edit: table name - Cycle Time 2):   And I also have a date table:   I want to be able to count: 1) How many items are In Progre...
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, FlowViz 

For example, on the 19th March - there are 4 items 'In Progress' - TP-5, TP-6, TP-7 and TP-9

TP-5, TP-6, TP-7 have an age of 2, TP-9 would have an age of 0

I can't seem to understand the example from your sample data properly.
Can you explain in more detail how the above example works

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.