WOW! I think i will try to apply this to what i need; Day over Day changes. I hope I'm saying that right. I'd like to see the changes of calls made per day.
Hi Andy, It will be nice if you'd one day do the same same video with more explanation on the table calc or even a videos on exclusively on table cal ( I specifically mean Edit table calculation). Thanks
I used the same method as Andy suggested for previous week but i am getting a rolling sum value.Like week 1 and week 2 added in week 3 .....Can you help on this
I want to compare versus the best week, any ideas? I was able to rank the weeks in terms of sales but I don't know how to compare the current week vs the best week
Need some help! I followed the same procedures shown in the video but the moment I shift the Year and Month dimensions to the Details button, the calculated figures from the other months all shown up again. Possible to get some help on this please? Thanks in advance.
Hi, Thank you for the video :) Its working till the last step like adding 'latest week' to filter pane and selecting True. When I tried removing Year and week number from Rows to Details pane, it is giving all values instead of maintaining last row. Can you please let me know how to resolve it? I followed all the steps from the video. Thanks in advance!
Hi Andy - Thanks for this Great video. Can you please help with the logic to calculate day over day sales values like i want to see( Todays sales, Yesterdays sales, difference of Todays - Yesterday sales and difference in percentage of Todays - Yesterday sales? It will be very help full if you help with this logic in calculated field. Thanks in advance!.
Excellent. Works perfectly for what I am doing. The only thing I can't figure out, is how to 2 step the text color (red/green for negative/positive percentages respectively). If you have any advice, it would be greatly appreciated. If I add latest_wow_% to colors, and try to select stepped color, the start and end values are NULL and I am unable to modify them.
please help... i spend nearly one hour trying to figure out the solution ... After following the tutorial I am trying to add a filter for the last order week into filters so users can pick and choose the filter. As soon as I add a filter, the values are disappearing
How can we do this if we have multiple KPIs, is it necessary we have to repeat the process for sales, profit, loss etc???? Or is there short cut for that
@@vizwiz but I thought the goal of that formula was to ensure that the calculation only applied to weeks that had been completed in the calendar year in question, as in yes we wouldn't want to calculate WoW difference for a week that wasn't over yet ... the only week not over yet is the one we are currently in, and as such it should only apply to the most recent week; would you agree? If so I'd love to get your thoughts; I did that same formula and see a lot of weeks with blanks.
That error means that you are missing a parentheses or something like that. Double check. If you did it exactly like it did, then you won’t get that error.
Is it me or the assumpion of max(datepart('weekday', [Order Date])=7) is incorect? Due to my knowledge it means, that within the week one specified day of week occurs (this weekday maybe e.g. Saturday or Sunday, the seventh day of week, depends on local settings) but it does not cover the need to take into consideration "full" week - the seven day period. I would appreciate if someone could answer that, thank you and regards
you can set it on end date of week on datasource level Steps: 1. Right click on the Data Source. 2. Navigate to Date Properties 3. Here you can change Week Start day, Fiscal year start and date format.
@@vizwiz Thank you. I think I got it working. I am trying to use the same concept but to work out average days, but I seem to be getting blanks in some completed weeks. my first calculation was to work out the Avg days between by using this calculation 1. AVG(DATEDIFF('day',[CreatedDate],[Start_Time__c])) Then I added this calculation to work out my completed weeks by doing this 2. IF WINDOW_MAX(MAX(DATEPART('weekday', [CreatedDate])))= 7 THEN WINDOW_AVG([Avg Days to complete an Inspection]) END When I put the completed week into the table I get missing weeks eg: Week 21 - Comp Wk 213.9 Week 22 Comp Wk ( Blank) Week 23 210.8 I cant seem to troubleshoot it. If you can help that would be great
Last() is a table calculation which happens against the data that's already in the view. Filtering by Week is part of the query that's sent to the database so the results that come back into Tableau would not include those weeks.
The trick is to figure out how to calculate the 13 weeks. Does it need to be a rolling 13 weeks? Or will you only display every 13th week? Can you post a link to a workbook?
@@vizwiz I had a similar question: As I get more and more data during the current week , how do I compare data of this week (Mon - Wed) to data from last week ( Mon- Wed) rather than comparing it to (Mon - Sun). Hope this helps Andy!!
I want to calculate the WoW views of articles and want to see if they are increased/decreased. Can anybody help? For example for 4/1/21 the view is 23 and for 11/1/21 the view is 25 for the same article. Like that i have 10k articles week wise
Hi Andy , I just wanted to ask one question could you please tell me. Jan feb March April 81 105 79 70 How should I do difference between Jan value and feb value where Jan and feb are not diff columns. They are under one column. Could you please tell me Thankyou
Great walkthrough! Not many people can pull this off with a 4% battery to start with.
Tableau is a great tool, but the fact that it takes that much work and thought to calculate Latest WOW% to me shows some of its weaknesses.
Very Helpful...I can't thank you enough.
coming to your vid in 2021..Still useful thanks a lot
WOW! I think i will try to apply this to what i need; Day over Day changes. I hope I'm saying that right. I'd like to see the changes of calls made per day.
Very helpful. thanks!
Thank you for the great video!!!
the best Tableau specialist ever! Can we invite you for a training?
Thanq so much .. have a great day
Great Work
Hi Andy, It will be nice if you'd one day do the same same video with more explanation on the table calc or even a videos on exclusively on table cal ( I specifically mean Edit table calculation).
Thanks
Like this? www.vizwiz.com/2017/02/table-calcs.html
I used the same method as Andy suggested for previous week but i am getting a rolling sum value.Like week 1 and week 2 added in week 3 .....Can you help on this
Brilliant thankyou
excellent
Hi thank you for the great video! Do you know how to compare the current week data to the last 4/10 week's average in Tableau?
I want to compare versus the best week, any ideas? I was able to rank the weeks in terms of sales but I don't know how to compare the current week vs the best week
Need some help! I followed the same procedures shown in the video but the moment I shift the Year and Month dimensions to the Details button, the calculated figures from the other months all shown up again. Possible to get some help on this please? Thanks in advance.
Hi, Thank you for the video :) Its working till the last step like adding 'latest week' to filter pane and selecting True. When I tried removing Year and week number from Rows to Details pane, it is giving all values instead of maintaining last row. Can you please let me know how to resolve it? I followed all the steps from the video. Thanks in advance!
I hate to say it…but, you must have missed a step along the way. I went through the steps again myself and they worked.
Hi Andy - Thanks for this Great video. Can you please help with the logic to calculate day over day sales values like i want to see( Todays sales, Yesterdays sales, difference of Todays - Yesterday sales and difference in percentage of Todays - Yesterday sales? It will be very help full if you help with this logic in calculated field. Thanks in advance!.
It should be the same process as this video except using days instead of weeks. I'll create a video either way. Hopefully next week.
@@vizwiz Thanks, Andy. I would be very grateful if you could create a video on this.
Excellent. Works perfectly for what I am doing. The only thing I can't figure out, is how to 2 step the text color (red/green for negative/positive percentages respectively). If you have any advice, it would be greatly appreciated. If I add latest_wow_% to colors, and try to select stepped color, the start and end values are NULL and I am unable to modify them.
please help... i spend nearly one hour trying to figure out the solution ... After following the tutorial I am trying to add a filter for the last order week into filters so users can pick and choose the filter. As soon as I add a filter, the values are disappearing
How can we do this if we have multiple KPIs, is it necessary we have to repeat the process for sales, profit, loss etc???? Or is there short cut for that
Yes, you have to repeat it.
@@vizwiz Thank you, its a great video
Why would another week other than week 53 for 2013 be blank? Week 53 of 2012 is done, so why is it blank?
Maybe there were no sales that week.
@@vizwiz but I thought the goal of that formula was to ensure that the calculation only applied to weeks that had been completed in the calendar year in question, as in yes we wouldn't want to calculate WoW difference for a week that wasn't over yet ... the only week not over yet is the one we are currently in, and as such it should only apply to the most recent week; would you agree? If so I'd love to get your thoughts; I did that same formula and see a lot of weeks with blanks.
Can I enter the week myself i.e. Week 2 to week 3 and week 1 to week2
Hi , I did the same but without using Window_MAX - why do you need this ? Thanks!
Which part?
@@vizwiz Hi , the calculation of "Completed Week Sales"
@@igorgolubochanski5485 What was your calculation?
Why when i create Laters WOW% appers an error as syntax error( maybe you are missing an operator). But i apply the same steps.
That error means that you are missing a parentheses or something like that. Double check. If you did it exactly like it did, then you won’t get that error.
Hi Can you please help me to find Last 3 days sales for every month dynamically
Find the max date for each month with an LOD. The a datediff function to get the latest 3 days.
Is it me or the assumpion of max(datepart('weekday', [Order Date])=7) is incorect? Due to my knowledge it means, that within the week one specified day of week occurs (this weekday maybe e.g. Saturday or Sunday, the seventh day of week, depends on local settings) but it does not cover the need to take into consideration "full" week - the seven day period. I would appreciate if someone could answer that, thank you and regards
you can set it on end date of week on datasource level
Steps:
1. Right click on the Data Source.
2. Navigate to Date Properties
3. Here you can change Week Start day, Fiscal year start and date format.
Hi, just struggling to do this by month. If i wanted to do this by month is it the same concept?
Should be pretty similar. Replace week with month in the calculations. This might help too. www.vizwiz.com/2017/03/latest-previous-prior.html
@@vizwiz Thank you. I think I got it working. I am trying to use the same concept but to work out average days, but I seem to be getting blanks in some completed weeks. my first calculation was to work out the Avg days between by using this calculation
1. AVG(DATEDIFF('day',[CreatedDate],[Start_Time__c]))
Then I added this calculation to work out my completed weeks by doing this
2. IF WINDOW_MAX(MAX(DATEPART('weekday', [CreatedDate])))= 7
THEN WINDOW_AVG([Avg Days to complete an Inspection])
END
When I put the completed week into the table I get missing weeks eg:
Week 21 - Comp Wk 213.9
Week 22 Comp Wk ( Blank)
Week 23 210.8
I cant seem to troubleshoot it.
If you can help that would be great
Please explain clearly, what is the logic behind this calculation
Can you explain why with the LAST () = 1, the calculated fields still work, but if you were to filter to just that week, they wouldn't?
Last() is a table calculation which happens against the data that's already in the view. Filtering by Week is part of the query that's sent to the database so the results that come back into Tableau would not include those weeks.
ok thanks for the explanation. That was helpful
How would you do this if you wanted to calculate 13 weeks by 13 weeks change? I can't get lookup() to sum multiple rows.
The trick is to figure out how to calculate the 13 weeks. Does it need to be a rolling 13 weeks? Or will you only display every 13th week? Can you post a link to a workbook?
Hey sorry about the delay. I figured it out just using Window_Sum
sir how if i want to compare uncomplete day in one week, let's 5 days current week to 5 day previous week. Thx
I don’t not understand your question. Can you make it clearer?
@@vizwiz I had a similar question: As I get more and more data during the current week , how do I compare data of this week (Mon - Wed) to data from last week ( Mon- Wed) rather than comparing it to (Mon - Sun). Hope this helps Andy!!
I want to calculate the WoW views of articles and want to see if they are increased/decreased. Can anybody help? For example for 4/1/21 the view is 23 and for 11/1/21 the view is 25 for the same article. Like that i have 10k articles week wise
Isn't that exactly what this tip covers?
I really didn't understand the last steps last week ..Iam confused totally
Hi Andy ,
I just wanted to ask one question could you please tell me.
Jan feb March April
81 105 79 70
How should I do difference between Jan value and feb value where Jan and feb are not diff columns.
They are under one column.
Could you please tell me
Thankyou