strangeways/GoogleSheet_last12rows_sparkline.md

Last active May 24, 2018 13:36

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/strangeways/30d40a2399aaeb3fc72f.js"></script>
Save strangeways/30d40a2399aaeb3fc72f to your computer and use it in GitHub Desktop.

Download ZIP

Google Sheets formula to generate a sparkline chart from the last 12 rows with values in a given column

Raw

GoogleSheet_last12rows_sparkline.md

=SPARKLINE(FILTER(A2:A, ROW(A2:A)>(MAX(FILTER(ROW(A2:A), ISNUMBER(A2:A)))-12), ROW(A2:A)<=MAX(FILTER(ROW(A2:A), ISNUMBER(A2:A)))))

Exploded view of formula:

=SPARKLINE(
  FILTER(
    A2:A,
    ROW(A2:A) > (MAX(FILTER( ROW(A2:A) , ISNUMBER(A2:A))) - 12),
    ROW(A2:A) <= MAX(FILTER( ROW(A2:A) , ISNUMBER(A2:A)))
  )
)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment