I love how Anthony unlocks a complex dashboard, and presents in a way that so easy to follow. Thank you! Second Anthony at 20:25 (Tableau devs ... all lines off button pls) 😊
Amazing video! Watching your Tableau videos makes learning Tableau a lot of fun. Look forward to how to put all the charts together in a dashboard. So if you could also make a video for that one, it would be great!
This is great but I have a question on the Order Previous Year and the Customer Previous Year calcs. Why did you use Order ID and Customer ID in your IF/Then statement vs CountD of Order ID and CountD of Customer ID? Could you have written those as CountD instead of using CountD in your YoY calcs.
I remained consistent with the original dashboard design by Dmitry. I suppose you could aggregate in the formula and then when they are placed in the marks area the pills would show AGG(OrderId) to show that the OrderId is already summed. Give it a try and let us know!
Thanks for this session.. Extremely helpful. Just one question, on category bar, can we change the color of the percentage like red for negative value and green for positive value and also add up and down arrow. I'm trying similar thing but I don't know if thats possible.
Another way would be to duplicate the bar chart sheet as Anthony did. However, instead of drag and drop new dimensions to Rows you can double click the dimension you want to change out and write the name of the dimension to replace with. This will keep the formatting already applied to the previous dimension for the new one.
Hey there, I am following along and I am having trouble entering the calculated fields and getting the intended results. When I look at the data source my calculated fields 'sales selected field' only has calculated terms for one year, and 'sales previous feild have only null values because its the first year in the dataset. Any idea why the calculated field would only work for the first year? I can send you any info and thank for the great video!
@@AnthonySmoak Help! I am stuck at the Map portion of this tutorial. At 40:54 of this tutorial, my map shows only 1 color and the color diverging works, but it does not allow me to adjust centering (It appears locked), therefore my map only shows one color. Did I miss a step in the parameter section? Thanks for your help.
I love how Anthony unlocks a complex dashboard, and presents in a way that so easy to follow. Thank you! Second Anthony at 20:25 (Tableau devs ... all lines off button pls) 😊
Much appreciated Shirley. We definitely need that all lines off button!
Thanks! Can't wait to see Part 2!
Great walkthrough. Please do more of these as they're extremely helpful.
Thank you for the feedback!
Thanks Anthony! Really helpful
Much appreciated!
Amazing video! Watching your Tableau videos makes learning Tableau a lot of fun. Look forward to how to put all the charts together in a dashboard. So if you could also make a video for that one, it would be great!
Thanks for the comment. Recording and editing this video took a lot of effort so it's great to hear that you took some value from watching!
Hey, this was awesome :) i look forward to more guides
Thank you!
This is great but I have a question on the Order Previous Year and the Customer Previous Year calcs. Why did you use Order ID and Customer ID in your IF/Then statement vs CountD of Order ID and CountD of Customer ID? Could you have written those as CountD instead of using CountD in your YoY calcs.
I remained consistent with the original dashboard design by Dmitry. I suppose you could aggregate in the formula and then when they are placed in the marks area the pills would show AGG(OrderId) to show that the OrderId is already summed. Give it a try and let us know!
Waiting for Part 2
Thanks for this session.. Extremely helpful. Just one question, on category bar, can we change the color of the percentage like red for negative value and green for positive value and also add up and down arrow. I'm trying similar thing but I don't know if thats possible.
We can use copy formatting from one worksheet to another worksheet for bar chart to save time😊
Another way would be to duplicate the bar chart sheet as Anthony did. However, instead of drag and drop new dimensions to Rows you can double click the dimension you want to change out and write the name of the dimension to replace with. This will keep the formatting already applied to the previous dimension for the new one.
For the calculated fields I created for Sales Selected Year and Sales Previous Year, all the values are null
Interesting , definitely double-check the formulas or your dataset.
Hey there, I am following along and I am having trouble entering the calculated fields and getting the intended results. When I look at the data source my calculated fields 'sales selected field' only has calculated terms for one year, and 'sales previous feild have only null values because its the first year in the dataset. Any idea why the calculated field would only work for the first year? I can send you any info and thank for the great video!
Hello! Where can I find the dataset to follow along? Could you please post it ?
@@jackiehay2914 Just do a Google search for "Tableau Superstore dataset". Some version of the file should be in multiple places.
@@AnthonySmoak Help! I am stuck at the Map portion of this tutorial. At 40:54 of this tutorial, my map shows only 1 color and the color diverging works, but it does not allow me to adjust centering (It appears locked), therefore my map only shows one color. Did I miss a step in the parameter section? Thanks for your help.
Hi anthony, can I get twbx of this dashboard? Thanks.
Check the description of this video.
Would help if you link the dashboards ?
👍 public.tableau.com/app/profile/anthony.smoak/viz/SuperstoreDashboardBuild/Dashboard1