Get Date of Story Point Change

Questions & Answers
1

I need the date a story point value of 1.00 is set and then when it is changed.
Bit of an explanation in case it matters: This company does not use story point values for their intended purpose. A Story Point value of 1 means something specific, but totally unrelated to the size of a task.

My understanding of tuples is limited to fields and possible values. So I can easily find the stories that currently have a Story Point =1 value…
(
[Issue Type].[Story],
[Status].[Pre-Test Ready],
[Story Points].[1.00]
)

“Pre-Test Ready” is Status Aggregate I created as we do a lot of measurements of issues in that range of statuses.

How do I get the dates for when the SP=1 value was set and then again (second column) when it was changed (to anything or nothing)?
I think it’s a [transition…something that I 'm missing… this doesn’t work:

(
[Issue Type].[Story],
[Status].[Pre-Test Ready],
[Story Points].[1.00],
[Measures].[Story Points change],
[Time].CurrentHierarchy.DefaultMember
)

Yes, the source is importing the value changes for story points.

VERY much appreciate the help.

2

Progress? Not sure.
I found this post ( Age Interval Dimension but depending on the Updated Date - Questions & Answers - eazyBI Community) and added the age since updated dimension.

I think this provides the age of unresolved issues… I was hopeful I could make it work for my situation, but it did not:

image
image938×570 29.7 KB

3

Hi @Camille

In the “Source Data” tab → “Edit” → “Custom fields” you can define a new calculated field “Story Points2” with a set-up like this (you’ll find the “Story Points” field ID in the General tab by hovering over the name of the field):

storypoints2
storypoints21530×2198 294 KB

Import this calculated field and then you can define a new measure in the Measures dimension with a formula like this:

TimestampToDate(
  (
    [Measures].[Transition to first timestamp],
    [Transition Field].[Story Points2],
    [Story Points2].[1]
  )
)

Be sure to set the Formatting to Date.

This measure should get you the Date and Time when the Issue was first assigned with 1 Story Point. Use another measure with the [Measures].[Transition from first timestamp] to get the date when the Issue was changed away from the 1 Story Point.

Let me know if this works as expected!
​Best regards,
​Nauris

1 Like
4

Thank you for the reply and the detailed steps @nauris.malitis

It looks like the measure is pulling the date the issue was created of issues that currently have a value of 1 SP.
For example: C32-1455 below was created on Feb 8, but SP = 1 was set on Sept 7
image

This is a mockup in Excel, but what I would really love to see if possible:

image
image924×533 17.7 KB

5

Hi @Camille

You should use the previously mentioned formula in the Measures dimension.

Define a new calculated measure “SP 1 date” in the Measures dimension with this formula:

TimestampToDate(
  (
    [Measures].[Transition to first timestamp],
    [Transition Field].[Story Points2],
    [Story Points2].[1]
  )
)

Then create the rest of the measures using other story points - [2], [3], etc in the measure.

Let me know if this works as expected!
​Best regards,
​Nauris