Percentage of request resolutions within one hour

Questions & Answers
1

Hello,
I am trying to create a report with % of tickets resolved within an hour. I tried creating a calculated measure as following, however, it does not help. To be honest, I referred to similar topic and tried to arrive at the following.

CASE WHEN
    [Issue].CurrentHierarchyMember.Level.Name = 'Issue'
THEN
    CASE
        WHEN [Measures].[Hours spent] <= 1
        THEN 1
    END
ELSE
    Sum(
        Filter(
            -- iterate through Issue dimension "Issue" level
            Descendants([Issue].CurrentMember,[Issue].[Issue]),
            -- return a set of issues matching condition
            [Measures].[Hours spent] <= 1
        ),
        -- evaluate the set of issues over the measure below
        [Measures].[Issues with hours spent]
    )
END

I know this would only give the number of issues and not the percentage but it doesn’t work.
Could you please let me know the issue with above logic. Any help here would be appreciated.

1 Like
2

Hello @shripad.dindorkar,

Thanks for posting your question!

Could you share a bit more about what you’re hoping to achieve with your report? Are you trying to find all the issues that were resolved within an hour of being submitted, or are you looking for the tickets being resolved and have less than 1 hour of time logged?

It would really help us give you the best answer if you could share your report definition, as some filters could impact the results you are getting in your report. If you don’t mind, please send your report definition to our support email (support@eazybi.com ) with a reference to this community post & we will take a closer look.

Best,
Marita // support@eazybi.com

1 Like