Workaround – Dynamic dates in Bar chart

Certain analyses produce category series - which by design do not keep any time parameters. With below workaround you can pass time information through analyses and show it in Bar chart.

Add formulas

We have formulas which output time parameters, add needed ones to Series list:
week()
month()
quarter()
year()
From their output you will build dynamic dates.

Cross sampling

  1. Mark series and 'Add selected series as new column' under a Group.
  2. Add each time formula in same Group with 'Add selected series as new single series column'.
  3. Add calculations.
  4. You can also rename columns for easier identification in next steps.

Sorting

If you are using it - don't sort time formulas. See below, that's all it is needed.

Bar chart

Prepare simple chart:

  1. Open Graph layout.
  2. Under Text leave only one series.
  3. Under Bar delete all series.
  4. On the left mark series and use 'Add new Text column' > 'One column per series with value'.

Add dynamic dates:

  1. Double-click on a cell.
  2. Roll out Dynamic properties.
  3. Find the right series for this cell, select Value.
  4. In next column you can use next/previous number i.e.; {s s5.Value}/{s s9.Value}, {s s6.Value}/{s s10.Value} and so on.