MADE EASY | Understanding How to build| YOY, MOM, WOW Calc | Tableau

Hello Everyone
In this easy made very #important #turorial video, we will discuss how to build logic for
#YOY, #MOM,#WOW,#qtd Calculations in #tableau , #tableauscenarios #tableauchallenge
For YTD,MTD and QTD
• MADE EASY | Understand...

[@TechiRahul]

If you need video on Challenge I asked please comment as yes

[@Sheebakhanam-y4e]

YES

[@sayalidivekar5882]

Yes

[@siri913]

in sample super store datasource, it is not showing current year data.

[@TechiRahul]

You need to create a calculation using Dateadd function to get data till current year

[@sumitchaudhari5815]

yes. make video on it using lod and tell us logic behind it also. most confusing part for me is LOD i am not able to understand them i know the concept of fixed, include, and exclude but do not understand when to use them and tableau server

[@TechiRahul]

Sure

[@elayarajakannan7213]

Yes

[@Shilpa-q3i]

Please make a video on UAT and documentation please rahul

[@TechiRahul]

Yeah Shilpa I am planning for that. Since this was continuation video had to post this. Mostly second video from here would be on your topic sorry for delay

[@shubhamchauhan2242]

For CY and PY, if we want to take an agg field instead of 'Sales', IF function shows an error that you cannot mix aggregated and non aggregated fields, how to counter that Rahul, please help

[@TechiRahul]

Share me ur calculation Wil chk once

[@shubhamchauhan2242]

If (Month([Date]) = [KPI Month]) AND (Year([Date]) = [Year MoM%]) THEN [cpKBA] ELSE 0 END here KPI month and Year MoM% are simple parameters to select Year and Month. And cpKBA is an Aggregated result where cpKBA = Media cost / Total KBAs and Total KBAs itself is a sum of 3 fields. Error is ‘cannot mix aggregated and non- aggregated comparisons or results in IF expressions’ Please help me, it would be highly appreciated, thank you

[@shubhamchauhan2242]

This calc field and calculations is showing perfect results for non aggegated fields like ‘media cost raw’ which is a non agg field in place of ‘cpKBA’

[@anveekshitha8]

Yes

[@supreethsuresh3515]

Yes

[@sivabalansiva1471]

Yes