How can i make a 12 rolling average but not static, i mean calculate for example for the current month the average sales of the previous 12 months including the current one?
Is there a workaround for this method when using a aggregate calculated field? I've got a ratio field (% of tickets per customer) and am trying to create a calculated field for the 12-month rolling average
Need Help : if I created a dynamic 13 month rolling filter by creating calculated field datetrunc and parameter on date. How can i trigger another filter which can give me value (comment for that month) of selected month which i am rolling in for. Cause its messing up the current month value as as its still taking up the value (comment for that month) and showing for all 13 month months.
Subscribed just now because I was stuck in calculation and this video helped me.
Glad, it was helpful. Thanks for your support!
Wonderful tutorial, this was 100% fulfil my requirement .... Thanks Alot
Glad to hear that
Best answer worked like a charm
Glad it was helpful!
Shown it perfectly!
Thank you!
To learn more, visit our website: visionforanalytics.com
How can i make a 12 rolling average but not static, i mean calculate for example for the current month the average sales of the previous 12 months including the current one?
Is there a workaround for this method when using a aggregate calculated field? I've got a ratio field (% of tickets per customer) and am trying to create a calculated field for the 12-month rolling average
Thank you!
You're welcome!
Thanks for sharing the Knowledge. Really your videos helping a lot of the seekers. Instead of date_diff/Date_trunc calculations can we use just LAST()
Glad you liked my videos. Last function can be used depending on the granularity of the data
@@TableauTutor Thank You
Need Help : if I created a dynamic 13 month rolling filter by creating calculated field datetrunc and parameter on date. How can i trigger another filter which can give me value (comment for that month) of selected month which i am rolling in for. Cause its messing up the current month value as as its still taking up the value (comment for that month) and showing for all 13 month months.
THIS IS STATIC MAKE DYNAMIC ONE
Please tell me how to display the sales for each month in a specific year
👌👌👌👌👌
can you please share how to calculate Rolling Value also?
can you add mom cuurent month vs previous month to the rolling data please and show as one more column
What do you mean by rolling data in this context?
I thought we can do without using date trunc by just using date diff.