Forum Discussion

kerblooy's avatar
kerblooy
Frequent Visitor
9 years ago

Create Line graph showing created vs solved tickets

I know the the title makes it sound like this is an easy problem, and it might be, but I'm at a complete loss.   I have Power BI Desktop with a Zendesk datasource.   I want to create a line graph...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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/

kerblooy's avatar
kerblooy
Frequent Visitor
9 years ago

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!