Sales comparison to always the same date (compare today vs. Nov 1st)

[Giridhar.Prabhu]

Hi @helu

You can filter in the calculated fields and not directly filter on the visualization.

Here’s an article to get you started.

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Hi @lbl You can use the Relative Dates on the parameters (may need to make more parameters) to automatically default to a given date that represents the time period, and can use those in your table headers. It’s not as flexible as being able to write your own calculated logic, but you should be able to get most time periods represented using this (prefix each with ‘Month of’ or ‘Week of’, then put the parameter there… [image] [image]

Regads,
Giri