Hi,
I'm new to tableau and a bit stuck on some calculations . I have the data listing how people are completing their tasks during sprint time, and I wish to have a calculate of how much time they spent on a task.
It suppose to be calculated based on this rule:
- If the resolution is resolved(not unresolved), take the original value from latest sprint date(Oct.25 in this example) - remaining value from first sprint date(Oct.15)
- I have a value to say "Yes" when it's the latest sprint date
- If the resolution is unresolved, take the Spent value from latest sprint date - Spent value from first sprint date
I just couldn't figure out how to get Original or remaining numbers based on the date. would it be possible to help me on this one? Thx!
Ideally to create a calculated field for this so I can get the time spent on each issue for further statistics.
Work book attached.
3 answers
