1 of 1 people found this helpful
You could try using Lookup() to compute the duration using the date in the previous row of your partition:
DATEDIFF('day', LOOKUP(ATTR([Updated Date]), -1), ATTR([Updated Date]))
Then to get your "AB" labels, use
LOOKUP()again to fetch it from the previous row:
LOOKUP(ATTR([stage]), -1) + ATTR([stage])
Please let me know if that helps.
2 of 2 people found this helpful
here is my view on it.
Create Calculated fields to generate Stage Change and Time Spent
Stage=attr([Stage])+''+LOOKUP(min([Stage]),1) this would give next stage along with current stage
so A,B,C,D is now converted to AB,BC,CD,NULL
this gives difference between current stage date and next stage.
To get similar look as you final result, you have to hide Date column and Exclude Null row.
and you can create bar chart as below for your analysis
Thanks Kajal and Amit.
Your solutions worked as desired.