Sparkline Error with Combined Data in Looker Studio

[juan_ortizo]

Hi!

When utilizing the scorecard chart and enabling the "sparkline" feature as a comparative progress bar, it functions as expected with a standard dataset. However, attempting to create the same chart using a join through Looker Studio's combined data functionality results in an error. Could anyone clarify why this occurs? Is the sparkline feature incompatible with combined data sources?

Thanks!

[ArkadyZagdan]

Hi! @juan_ortizo 
I  am not 100% sure but my hunch is the missing datestamps after joining data.
The date field dimension shoudl probably include all available date fields even when no Bookings occured in a given day.

[Mehdi_Oudjida · Accepted solution]

@juan_ortizo 

You are right. This is a known bug when it comes to activating the sparkline line of a scorecard with blended data. The easier workaround would be to create a sparkline independent chart, below your scorecard. And so, do the same for all your scorecards to keep a design consistency across them.

I hope it helps.

Mehdi