Reason is I dont know which axis I should use for bringing the month column as shown in the excpected result screenshot. I have attached a sample excel
Here is what I did with your sample data set, I measure names and values (see workbook attached) and I used a LOD calcutation however it seems to add up the values for 'may' in the 'count resolved'. If you have a suggestion?
The number of tickets closed on the month of May is 1 and not 3..
we could actually create a chart for # of tickets CREATED every month. # of tickets RESOLVED every month but as separate graphs / tables...
But the requirement here is... I have to bring both metrics in the same graph.. For example: The month MAY has 3 tickets CREATED but only one got closed in the same month..
could you please share the work book .?
belive it or not.. im breaking my head right now as im facing the same problem working with the same data set from lira database like yours.
i have tried the solution that you have mentioned in the How to combine 2 different charts? but im still getting the wrong number of resolved issues..!
please please... help me..!