Hello,

I can create Sparklines without issue and understand that I need to apply the offset function but that is where I come undone.
  • Row A includes dates
  • Row B includes the requisite data


I would like the sparkline to reflect trends in accordance with the last 30 days only, disregarding the data before last 30 days.

Can anyone suggest what function I should apply? If my explanation isn't overly clear please let me know, happy to attach a document if necessary.

Sal