Displaying two metrics (year and month) in y-axis in a line graph.
Hi All,
I have 2 queries -
1. I want to display the year and month in the y axis in a line graph. I am able to do the same in a bar chart by creating a dummy in the expression field but its not working for the line chart.
2. I want to display the months in a proper interval. For eg - for all the years the month should show Jan,Jun, Sep & Dec. This is something which we can do in excel. I am not sure how to do it on QV.
I have attached the format in which i want the graph.