EazyBI report to get list of issues updated by a User for a period

[Karthika_Natarajan]

Hi,

I want to get the list of issues updated by a user for a period say last 24hrs. Basically a user activity report. Can this be done?

Thanks in advance.

Karthika

[Nauris Malitis -eazyBI-]

Hi @Karthika_Natarajan 

You can create a report that will return the number of issues updated today and yesterday by the issue Assignees, as there is no simple way to import the info of each update author.

Use the Assignee dimension in the Rows section, select the "Issues last updated" measure from the Measures dimension and use the Time dimension in Pages to filter the time frame.

You can define a new calculated member in the Time dimension that will allow you to filter issues updated today and yesterday with a formula like this:

Aggregate(
[Time].[Day].DateMembersBetween('yesterday', 'today')
)

Expand the Assignee dimension in the Rows section, and you will see the number of updated issues by each issue Assignee.

I hope this fits your use case!

Best regards,

Nauris / support@eazybi.com