6 ай бұрын
7 ай бұрын
8 ай бұрын
9 ай бұрын
Жыл бұрын
Жыл бұрын
2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
Пікірлер
@razor5352 16 сағат бұрын
Now I understand the difference. Great video lesson 👍👍👍
@mnvsaikiran 3 күн бұрын
Very nice but the video is fast. Please see if you can make it go slow.
@AnthonySmoak 3 күн бұрын
Adjust your playback speed in the settings.
@oizysss 3 күн бұрын
Hey, why my SUM(Sales Selected Year) is null?
@jaygibbs7218 4 күн бұрын
I cant get my button to execute I click it and nothing I tried this 3 times and I dont see anything wrong
@AnthonySmoak 4 күн бұрын
@@jaygibbs7218 I assume you have design mode turned off and your code is placed in the on click action?
@yoseppramudito8890 5 күн бұрын
I still use this method. Are there any other methods, or is it still the same?
@RIVASCOSTA 10 күн бұрын
Hi, thank you, I dont have the option "MAKEDATE", do you know if is it normal? If yes, is there any other formula?
@AnthonySmoak 10 күн бұрын
You must be using a live connection which doesn't accommodate MAKEDATE. Try the solution offered here: or switch to an extract community.tableau.com/s/question/0D54T00000C6mzeSAB/makedate-function-workaround
@TheBinary0101 12 күн бұрын
Super !! thx lots .. subscribed
@AnthonySmoak 12 күн бұрын
Much appreciated!
@USA_to_Asia_in_2024 13 күн бұрын
Thank you Brother Smoak.
@AnthonySmoak 13 күн бұрын
@@USA_to_Asia_in_2024 Thank you!
@DayJones-wb7ig 16 күн бұрын
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!
@lizcameron3299 16 күн бұрын
Curious: what would I do if the duration would be over 20 years? Would I still have to enter the # of days?
@jackiehay2914 17 күн бұрын
Hello! Where can I find the dataset to follow along? Could you please post it ?
@AnthonySmoak 17 күн бұрын
@@jackiehay2914 Just do a Google search for "Tableau Superstore dataset". Some version of the file should be in multiple places.
@jackiehay2914 5 күн бұрын
@@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.
@williambeasley838 18 күн бұрын
So, that is a nice feature. What about the reset button itself? i notice it stays highlighted as well when you click it. Mine does that and it will not remove the highlight until i click it again.
@paulpostma6520 19 күн бұрын
Would better without the music - too distracting
@KennelRottweiler-Haus 23 күн бұрын
Waiting for Part 2
@calebbrady11 27 күн бұрын
Thank you, Anthony. Very helpful!
@AnthonySmoak 27 күн бұрын
Thank you for the comment!
@YashadaKul Ай бұрын
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!
@AnthonySmoak Ай бұрын
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!
@Cavalier70 Ай бұрын
Way to hard to follow and disjointed
@AnthonySmoak Ай бұрын
Nothing worth having comes easy.
@thehunter11 Ай бұрын
We're having a serious PARTITIONING case here. You the truth man, thanks.
@AnthonySmoak Ай бұрын
You're the real MVP, thanks for the comment!
@kailashsathia3080 Ай бұрын
LOVE YOUR CONTENT. HELPED ME A TON AT WORK.
@AnthonySmoak Ай бұрын
I'm very glad to hear that, thanks for sharing!
@Ivy_1057 Ай бұрын
Thank you for the lesson! 👏
@AnthonySmoak Ай бұрын
Thanks for leaving a comment!
@AllisonRosenbaum Ай бұрын
Very clear instructions! I'm learning a lot from your tutorials. However, I can't find a way to make a bullet chart on Tableau Public. I don't see an option for a fixed size when building the bar chart; is this something that's only possible on Tableau Desktop?
@anuskasarkar2183 Ай бұрын
This is helpful but when I am downloading the extract from tableau server, I am getting duplicate values
@kennisrogers2585 Ай бұрын
Hey, this was awesome :) i look forward to more guides
@AnthonySmoak Ай бұрын
Thank you!
@tejeswarreddy6260 Ай бұрын
How to create a connection when other user opens the Excel file , the data will refresh automatically, without prompting to authenticate to SQL
@mirrrvelll5164 Ай бұрын
Great to follow this. I managed to do it/implement it into my report. Thanks and you got +1 new sub =)
@AnthonySmoak Ай бұрын
Glad to hear it, thank you!
@anthonylozito691 Ай бұрын
Helped!
@noelfrias2361 Ай бұрын
Hi Anthony - thank you for the demonstration. I am in the process of doing a salary and promotion request for my job. I understand the fundamentals of tableau but my question was how can I incorporate text only to show some community events, field and vendor events like that?
@El_prof86 Ай бұрын
great videos !!!! Simple and Nice man !! tnx
@AnthonySmoak Ай бұрын
Simple and nice is what I was aiming for, thank you!
@yassera.rahman4100 Ай бұрын
Great explanation. Thanks
@AnthonySmoak Ай бұрын
Thank you!
@fidi7400 Ай бұрын
Thanks so much, you really helped me understanding grouping by and partition by. My lines of code now work as intended!
@AnthonySmoak Ай бұрын
Fantastic, glad to hear that you learned something new!
@RamMukesh86 Ай бұрын
We can use copy formatting from one worksheet to another worksheet for bar chart to save time😊
@filiporg5799 27 күн бұрын
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.
@aspirationalaudio4025 Ай бұрын
Really Thank you for your explanation 😍😍 a New Like and subscription From Egypt 🤙
@AnthonySmoak Ай бұрын
Thank you for supporting the channel!
@hameheroj4030 Ай бұрын
Saved my day. Thank you. Trying to handle csv via oythpn script and always getting all values in one column, separated by the comma. Now I fixed it. Very unconvinient option in windows :/
@AnthonySmoak Ай бұрын
Glad to hear it!
@coreypea6225 Ай бұрын
Thank you man, you are a lifesaver!
@AnthonySmoak Ай бұрын
Thanks for the comment, much appreciated!
@jdwyer4851 Ай бұрын
how is this in anyway better than MSQuery where i could just do {Call MyStoredProcedure(?,?,?)}. Not a bit of VBA or a macro, i could just assign the 3 parameters to cells on the sheet.
@AnthonySmoak Ай бұрын
I know MSQuery is listed as an older legacy option and you have to manually enable it in the latest version of Office 365 Excel (will it continue to be supported like VBA)? However, you have given me an option to test, I'll let you know how it goes.
@jdwyer4851 Ай бұрын
@@AnthonySmoak My complaint is really with Microsoft. They took something simple and replaced it with a nightmare. I'm a programmer so other than disliking VBA, i have no problem with this approach other than it used to be very simple with MSQuery.
@AnthonySmoak 24 күн бұрын
@@jdwyer4851 I made a video exploring the MS Query approach. Thanks for the comment. kzbin.info/www/bejne/aKC3XoOenMh-l5ofeature=shared
@jdwyer4851 22 күн бұрын
@@AnthonySmoak Thank you for doing that. Microsoft has buried MSQuery on the current Excel version and you have to add it to the menu yourself. I hope that it doesn't go away completely, or at least if it does Microsoft could replace it something that its as equally simple. I'm a programmer, but for fast ad-hoc solutions I can turnout an Excel doc calling a stored procedure in minutes. Perhaps the more people who know about and use MSQuery the less likely it gets killed by Microsoft.
@timpanister73 Ай бұрын
Thanks! Can't wait to see Part 2!
@jasonbehrens3992 Ай бұрын
🎓
@jatinchauhan5875 Ай бұрын
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.
@TransformingTheFosters 2 ай бұрын
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.
@AnthonySmoak Ай бұрын
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!
@dispelDarkness_21 2 ай бұрын
bro, nice one. An humble request: kindly turn off background music, its bothering.
@TH-vw4qn 2 ай бұрын
Great walkthrough. Please do more of these as they're extremely helpful.
@AnthonySmoak 2 ай бұрын
Thank you for the feedback!
@srem1971 2 ай бұрын
Thanks Anthony! Really helpful
@AnthonySmoak 2 ай бұрын
Much appreciated!
@ragragrec1 2 ай бұрын
Would help if you link the dashboards ?
@AnthonySmoak 2 ай бұрын
👍 public.tableau.com/app/profile/anthony.smoak/viz/SuperstoreDashboardBuild/Dashboard1
@im4485 2 ай бұрын
Tableau sucks
@AnthonySmoak 2 ай бұрын
Microsoft has entered the chat..
@TjandraPutra-xw4yq 2 ай бұрын
thank you sir!
@fredwooten14 2 ай бұрын
I Got you Brother Smoak!🔥
@AnthonySmoak 2 ай бұрын
🤜 Respect!
@muhammadnasiralimalik1288 2 ай бұрын
How we bring address in result tab plz plz guide me.
@Hung-gr9id 2 ай бұрын
Rất hữu ích. tks
@AnthonySmoak 2 ай бұрын
Cảm ơn
@saikyawlin663 2 ай бұрын
Hi Anthony, so whenever my mssql data change, the data in excel would change after refresh right? What if I want to do an inner join, so I just change the query in the source in power query? Thank you so much.
@saikyawlin663 2 ай бұрын
Or do i import both tables and also change the query?
@AnthonySmoak 2 ай бұрын
@@saikyawlin663 Your data will refresh based upon what is in SQL Server, yes. Watch the videos in this series to connect Excel to a SQL query. kzbin.info/aero/PLRNrM8SIqgQZ4u5yGSlVNeGgej1lcwLwr
@AnthonySmoak 2 ай бұрын
Glad to hear it and thanks for the comment!