• Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.

Reply to thread

GOOGLE DATA STUDIO HACK


By default, Google Data Studio forces you to choose between either a Month over Month or Year over Year comparison (the up/down red/green arrows below each scorecard metric).


However, dealerships typically want to see how they compare to BOTH the prior month AND the prior year.


To accomplish this, all you have to do is:

1) Duplicate the scorecard metric

2) Change the comparison date range

3) Set the label font color to white so the only thing left visible is the second set of comparison up/down arrows

4) Add text below each comparison metric to distinguish between MoM vs YoY


[ATTACH=full]4241[/ATTACH]