MoM calculation variations

[ErikG]

Hi @abreddyk
did you checked

YoY% , MoM% and QoQ% calculation for numeric month and year values

The equivalent of Group By in a pivot table would just be the Rows and Columns field wells. Keep in mind you should expect to see blank values for your firs tyear since there is no data to compare to, but you should se values for newest years. What should the final visual look like? Are you trying to show a row or column for each month (in a table), or just the most recent month (in a KPI), or something else?

How to calculate MOM difference?

I wan to create one single column in the end which would give the MoM difference between the last two available months in the data in this case nov and october. @thomask [image]

Calculate MoM% and QoQ calculation within a Date range

Hello, I am looking to do a YoY%, MoM% and QoQ% difference for the following data within a date range. I currently used this calculated fields below which worked ok if the date range picked is for 1 month for example 1st -31st July: Current Period: ifelse({snapshot_day}>=${StartDate} and {snapshot_day}<=${EndDate},1,0) Same Period Last Year: ifelse({snapshot_day}>=addDateTime(-1,‘YYYY’,${StartDate}) AND {snapshot_day}<=addDateTime(-1,‘YYYY’,${EndDate}),1,0) YoY %: sum({Current Period}) / sum…

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

Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…

BR