Dear community,
I'm struggling to produce a continuous line chart which i would then like to attach to a table as sparklines. This is a sample of what it looks like:
Apologies if this has a really simple answer, but I've been giving myself a headache trying to figure it out and whilst I can get various tables and charts, I can't get continuity between the values in the quarter fields. I also don't know how to combine it to get a table with sparklines, but I'll worry about that next
Thanks,
Mitch
Hi Mitch,
I see your title, but is there a reason you're unable to re-structure your data? I'm unsure if you can build a trendline without having your dates in the same column. If you pivot it you can do it very straightforwardly. Even with just having the "Q3-17" as your date column, you can parse this to convert into a useful date.
Best,
Bryce
