Forum Discussion
Create Line graph showing created vs solved tickets
I'm wondering if you are using the wrong approach. I'd be expecting that you want to create a measure to count Tickets created and a separate measure for count of solved tickets. Then on the graph, both these measures can share the same Date axis.
Thanks for the reply!
That is an easier way to approach, sadly the date thing still remains a problem.
One point I forgot to mention in the OP is that sometimes the created date and the solved date are not the same.
So if a ticket was created on 5/1 and solved on 5/2, which date would be plotted on the graph?
Is there a way I can get it to plot both the created and solved date for the same ticket?
My thought here is that "Date Created" would be used in the creation metric and "Date Solved" for the solved metric. The graph would need a common axis, which would be best served by linking your table to a Dimension date table. This dimension date table is then used as your axis.
Here you might need to consider how your measures are written, as you might need to use some sort of ALL style statements to ensure that the context of the first measure isn't upsetting the context of the 2nd.
Here is some info on Date Dimensions:
http://www.agilebi.com.au/power-bi-date-dimension/Thank you very much for all the info, sounds like what you says works and my lack of knowledge/experience with BI just makes this problem seem a lot more complicated than it is.
I'll do some reading and hopefully, I can get this done.
Thanks again!