Superb Job both of you !! Question @ 49:40 regarding Prior month. Say...if the current month is Nov 2019 (last day of month= 11/30/2019) , below calculation will not include last day of Oct 2019 i.e. 10/31/2019 in Prior month. [Order Date] = DATETRUNC('month',DATEADD("month",-1,[Reporting End])) and DAY([Order Date])
Awesome! I'm not saying it's magic but it's magic. One question: at 49:41 I think that the lower bound of "Prior" should be: DATETRUNC("month",DATEADD("month",-1,[Reporting End]))
That's a lot of tips in under an hour. Good work.
For top and bottom 5, instead of sets, easy way is to calc field, index
Superb Job both of you !!
Question @ 49:40 regarding Prior month.
Say...if the current month is Nov 2019 (last day of month= 11/30/2019) , below calculation will not include last day of Oct 2019 i.e. 10/31/2019 in Prior month.
[Order Date] = DATETRUNC('month',DATEADD("month",-1,[Reporting End]))
and DAY([Order Date])
Awesome! I'm not saying it's magic but it's magic.
One question: at 49:41
I think that the lower bound of "Prior" should be:
DATETRUNC("month",DATEADD("month",-1,[Reporting End]))
Fantastic information. These guys rock. @ScarletVizion
Fantastic!!! Is Luke's dashboard available on Table public? I couldn't find it. I'm interested in the KPI section. Thanks!!
Brilliant work gentlemen!! Is the workbook available on the Public forum? I am not able to find it.
Thanks again for a job well done.
@Jacob Metzger thanks a lot!
Is there any chance to download the workbook of this?
interesting. Thank you
Amazing !!!!
great!
Miss the @andykriebal.. He is the best