Hi.
Has anyone created a measure for JSD satisfaction results that displays the confidence interval? I was able to create a measure that displays the sample size:
[Measures].[Issues with satisfaction date]/[Measures].[Issues resolved count]
Now I need to show how many reporters took the satisfaction survey more than once (and how many times) and what percent of the sample size (above) that is in order to display the confidence interval of the survey
R/S
Vanessa
Hi @vanessa!
By default, eazyBI is not importing the changes in Satisfaction, but you can add Advanced settings to import value changes of satisfaction date. The following settings would be necessary; change NNNNN to Satisfaction date customfield ID:
[jira.customfield_NNNNN]
changes = true
After updating the Advanced settings and importing value changes for the Satisfaction date field, you can write MDX formulas to Sum how many times the satisfaction was changed (if there are more than one previous satisfaction dates):
Sum(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
NOT IsEmpty([Issue].CurrentMember.get("Satisfaction date old values"))
AND [Measures].[Issues resolved] > 0
),
NonZero(
Len(
[Measures].[Issue Satisfaction date old values]
) -
Len(Replace(
[Measures].[Issue Satisfaction date old values], ',', ''
))
)
)
Or count issues that have filled out satisfaction survey more than once:
NonZero(Count(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
NOT IsEmpty([Issue].CurrentMember.get("Satisfaction date old values"))
AND [Measures].[Issues resolved] > 0
AND
Len(
CoalesceEmpty([Measures].[Issue Satisfaction date old values], '')
) -
Len(Replace(
CoalesceEmpty([Measures].[Issue Satisfaction date old values], ''), ',', ''
)) > 0
)))
Used with Time, these two measures would return the value on the issue resolution date, and you can use any of them for further calculations.
Let me know if I missed something and you have some further questions!
Lauma / support@eazybi.com