I want to use Performance Analytics to show tickets opened by location so that even if a user's location changes, it will not modify the report (for historical context.) I can create a normal report to show a bar graph with location on the x-axis and

[Dan R3]

I want to create a dashboard view that shows a bar graph for a single assignment group that has an x-axis of locations and y-axis of number of tickets opened.

When I create an indicator it seems to default to simply showing me the number of tickets on y-axis and date on x-axis.

How can I change this so the x-axis shows as "location" (I created a new field on the sys_user table called u_location). My goal is to have a bar graph that shows "Opened tickets, (sorted by opened by's location) and have data added on a daily basis to create a 7-day view. I'm okay if we need to stack the bars (locations) on top of each other.

I thought of just using "reports" for this, but if a user moves locations, and their record is updated with the new location, it will mess up any historical data that may have existing.

Anyone have a good solution? 

[Dan R3 · Accepted solution]

Never got a response on this but found a solution.

So Performance Analytics is really for understanding trends, I was looking to utilize PA for the job data collection it does. Not really the best tool to use for what I was doing.

What I decided to do was add a new field to the incident table called "incident location" and created a rule so the user who opened the ticket, their location on their user profile would copy to this "incident location" field. If the user, then transferred depts, 'the incident location' would not change since it's no longer referencing the user's profile.

I've heard there is a method using data sources for this however I was unable to get that to work properly.