Plotting max column values for pivoted months only

  • 2 March 2017
  • 2 replies

I would like to plot table data such that only the pivoted months and corresponding max value for each month’s column is shown. So far I’ve only been able to plot the individual days along with max value for the whole month. Is hiding individual days (the rows) possible? It would be okay to either plot “2017-01”, “2017-02”, etc. or the actual date of each month’s max value (e.g. “2017-01-29”).

2 replies

Awesome, thank you rufus for such a simple solution!

Userlevel 3

A possible solution here would be to limit the rows plotted to the first row:

If we also hide the Axis Value Labels:

Then we have two columns, one for each month: