I’ve a bugtracker system and I want to extracthistorical information about tickets’ open/close.
First of all, I created a master calendar linkedto opendate and another linked to closedate.
The problem is that I don’t know how analyzing thedata using a graph chart. I set MonthName (refers to opendate calendar) asDimesion, Count(opendate) and Count(closedate) as expressions.
If ticket is opened in January and closed inFebruary, I’d like to see two columns (one –open- in Jan, second-close- inFeb).
Probably you are looking for the attached example. I have taken the two dates from your tickets table to demonstrate it.
What I understand is you need to show the number of tickets closed at various months for the tickets opened in a particular month. Hope my understanding is correct.
Please have a look at the attached example and let me know. Attaching the Excel file with the dates and QVW file with the required graph.
Please attach a sample QVW to make analysing your issue a bit quicker. If it has sensitive data, please use the Scrambling function to make data unreadable.
Unfortunately you can not accomplish such a graph, since your data in reality goes over two different dimensions by having two calendars. Only way to get around this is to have the data presented over the same dimensions, being one general calendar.
The quickest way around this is to do exactly as Erich proposed above. The reason for this is that by linking to fields from the datat table to the calender table will lead to a synthetic key. The data model will allow you to plot the way you want, bu thte result might not be fully trustable. By adding event rows as suggested you will on the other hand be in full control over your data model.
Not clear over why you can not alter the data model, but I am quite sure that the change is quite easy to implement and enable you to do what you want in a feasible way.
Probably you are looking for the attached example. I have taken the two dates from your tickets table to demonstrate it.
What I understand is you need to show the number of tickets closed at various months for the tickets opened in a particular month. Hope my understanding is correct.
Please have a look at the attached example and let me know. Attaching the Excel file with the dates and QVW file with the required graph.
If you are going to rewrite the script any way, I really think it is a better structure to have a event focused fact table and link it to a calendar. This will give a much better overview from a designer perspective and better possibilities to analyse the data, by doing set analysis over dates and states.
Consider the possibilty to not just solve a specific current requirement, but also opening up for other analysis options in the future. It is much easier to make a proper data modelling from the begining, than to have to redo everything later on when you want to add addtional features to your application.
