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

[helu]

Hi team,

I am trying to compare my total sales to a static date (always compare it to Nov 1st). When selecting the pre-built fields, I can only compare MoM/QoQ/YoY, but not to a static date. How would this work?

[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

[Brett]

Hi @helu,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @helu,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!