Jump to content

Reporting- Row limitation


Joyce
 Share

Recommended Posts

Hi,

As there is limitation on amount of rows which can be moved to PowerBI reporting, is there a way to group by date ( either logged or resolved) and do a count  on the month within the date?

We would like trend ticket logged/ Resolved  monthly for the past 12 month, but currently as the volume of tickets increase we can only review 3 month at a time.

 

Thanks.

Kind Regards,

 

 

Link to comment
Share on other sites

@Joyce have you looked at the Measures in Advanced Analytics (if you have the module)?  this allows for the trending, date based and will allow for the creation of charts for the role based dashboards?

image.png

Then creating charts off these measures 

image.png

Alternatively you can use the request list - with the views, charts and personal dashboard for a chosen year:

image.png

Just use the view clause builder to build the logic for the view, and then create a chart based on either raised on or resolved on for example.

Hope that helps 

 

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...