Is there a reason why you cannot change the legend labels in a Period over Period chart type?

jakebutterfield

I'd love if there was a quick way you could change them like you can to the y-axis for example when you click the dropdown.

I know there is a way in a normal bar + line chart to make a beast mode for the time period you want and add it to series to manually plot the bar and line against each other a year apart but I have never been able to make that work.

ST_Superman

Looks like the series that you were using is Year. I would try creating a calculated field. Assuming you don't have any future dates in your data you could do something like this:

CASE
WHEN
DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 12 MONTH), INTERVAL DAYOFMONTH(CURDATE())-1)
> DateField
THEN 'Current'
WHEN
DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 24 MONTH), INTERVAL DAYOFMONTH(CURDATE())-1)
> DateField
THEN 'Previous'
END

You could then place this in your filter and select 'Current' and 'Previous'. Then use this field as your series as well. You can change the "Current" or "Previous" in the formula to whatever you want the label to say