PA: Year to date comparison

User205728
Tera Expert

Hi all,

I am working on Geneva with PA and have received the following requirement from the client: They want to compare the total number of incidents created this year to date, compared to the same date of last year year to date.

So this would mean that if the number of incidents created in 2016 is 1000 on from Jan 1st until June 1, compare the number of incidents that has been created from Jan 1st until June 1st 2015.

I figured that the Year to date sum option could prove to be the solution, but unfortunately it is not possible to select that specific time aggregation.

I have tried using the times series: previous period chart comparison, but then it only compares the same month of both years (ie april 2015 with april 2016, not jan-april 2015 with jan-april 2016). Quarter to date sum would be the closest approximation, but is not what the client is looking for.


Any idea how to tackle issue?

1 ACCEPTED SOLUTION

I have found the solution. By setting the indicator source to monthly, the year to sum aggregation becomes available. This will result in these type of graphs:




find_real_file.png


View solution in original post

12 REPLIES 12

Hello, I know this post is a bit old but i have this exact same reporting requirement right now, i've tried to follow your instructions, but I was wondering if you could show a couple screen shots of your settings to achieve this graph or any guidance at all would be greatly appreciated. 

Thank you

 

Suresh1
Tera Guru

Hi Kim,

 

I have similar requirement and wants to show the data for last year month vs this year month like below. How to achieve this.

 

find_real_file.png

 

Thanks,
Suresh

Faisal Shaikh
Tera Contributor

Is there a solution to this or not yet?