Ajinkya Abhyankar

Dec 12, 2020

Using LOD expressions & LOOKUP function to compute YoY/QoQ/WoW/MoM/DoD Profits

Requirement: I’ve created below bar chart showing States Vs SUM(Profits) for India. Requirement is to display Up/Down arrow based upon SUM(Profit) by State, YEAR(Order Date) on YoY. For example, If I select the Year=2016, then difference between SUM(Profits) should be calculated by Year for that particular state only. Sum(Profits) in…

Tableau

4 min read

Using LOD expressions & LOOKUP function to compute YoY/QoQ/WoW/MoM/DoD Profits

Dec 6, 2020

Computing grand totals of Discrete Measures using RUNNING SUM and LOOKUP filter in Tableau

Task: Create a detail report in Tableau and keep multiple discrete measures between 2 discrete dimensions. As we all know, continuous measures can’t be kept between 2 discrete fields, thus it is required to make continuous measures as discrete. After doing this, now if we want to display Grand Totals…

Tableau

3 min read

Dec 5, 2020

Calculate Delta,% Increase with Up/Down Arrows on YoY,QoQ,MoM,DoD using Lookup function in Tableau

Why Lookup? What is use of this function? LOOKUP function is used to look up and down a partition of rows and return a values in that field by specifying an offset. This can be used Lookup previous or next value within resp. partition to compute required calculation. LOOKUP is…

Delta

3 min read