Forum Discussion
Help with query across tables
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.
Sure thing:
On 17th March, the In Progress count should be 3 (TP-5, TP-6, TP-7) all of which should have an age of 0 (as they all went 'InProgress' that date).
On 18th March, the In Progress count should be 2 (TP-5, TP-6, - TP-7 is finished) both of which should have an age of 1 (as they all went 'InProgress' the date before).
On 19th March, the In Progress count should be 3 (TP-5, TP-6, TP-9) with an age of 2 for both TP-5 and TP-6, and an age of 0 for TP-9 (as it went 'InProgress' that date).
On 20th March, the In Progress count should be 1 (TP-9 - TP-5 and TP-6 are now finished) with an age of 1 (as it went 'InProgress' the date before).
I'm trying to create these two charts:
