Hi anthony, can I get twbx of this dashboard? Thanks.
@AnthonySmoak4 күн бұрын
Check the description of this video.
@politico35567 күн бұрын
Still new to my BI job, this helped!
@AnthonySmoak7 күн бұрын
Glad to hear it, thanks for sharing!
@VIRUSINGH33811 күн бұрын
Thank you very much, it's really helpful
@AnthonySmoak10 күн бұрын
@@VIRUSINGH338 Glad to hear it!
@XiZhang-j3i11 күн бұрын
have run time error 438 and the bug sits with Active.Workbook.Queries("LimitBalance").Refresh, could you please help?
@aravindsaraswatula256111 күн бұрын
Thank you.
@AnthonySmoak11 күн бұрын
You're welcome!
@artfotinich227613 күн бұрын
This is a great video. Relied on it heavily while building several reports. Thank you very much.
@AnthonySmoak11 күн бұрын
I appreciate you sharing this feedback, thank you!
@shirley95714 күн бұрын
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) 😊
@AnthonySmoak11 күн бұрын
Much appreciated Shirley. We definitely need that all lines off button!
@DarkArcticDay15 күн бұрын
Gov't fiscal analyst here, recently discovered our bloated financial database from the 80s has an SQL endpoint in the form of a DNS address accessible only inside the government network (i.e, within the VPN). I'm diving into the deep end on this. I've connected to APIs using PowerQuery, but I don't think this would be considered an API? Based on this video, I'm guessing "server" would be the DNS address, and "database" would be the database to be queried at that DNS address? Also, I'm totally going to be using this for production workbooks. But you'll be happy to know we move glacially, so a daily refresh automated via VBA keeps everything current. ;) Apparently they've been begging for people to use the SQL endpoint more but it's too complex for most folks so I'm forging new paths in trying to get this working. Thanks for the video, very informative!
@Child_of_the_most_High_God15 күн бұрын
I just stumbled across your videos, and I can definitely say great stuff
@AnthonySmoak15 күн бұрын
Thank you; make sure to tell a friend!
@mihirachandrasiri930720 күн бұрын
Thank you vey much!
@AnthonySmoak20 күн бұрын
Thanks for the comment!
@ParvanaGasimova22 күн бұрын
excellent amazing thanks
@AnthonySmoak11 күн бұрын
You're too kind!
@brothertoughlove22 күн бұрын
Good work 👍🏿
@AnthonySmoak22 күн бұрын
@@brothertoughlove Thank you!
@razor535223 күн бұрын
Now I understand the difference. Great video lesson 👍👍👍
@mnvsaikiran25 күн бұрын
Very nice but the video is fast. Please see if you can make it go slow.
@AnthonySmoak25 күн бұрын
Adjust your playback speed in the settings.
@oizysss25 күн бұрын
Hey, why my SUM(Sales Selected Year) is null?
@jaygibbs721827 күн бұрын
I cant get my button to execute I click it and nothing I tried this 3 times and I dont see anything wrong
@AnthonySmoak26 күн бұрын
@@jaygibbs7218 I assume you have design mode turned off and your code is placed in the on click action?
@yoseppramudito889028 күн бұрын
I still use this method. Are there any other methods, or is it still the same?
@AnthonySmoak10 күн бұрын
It depends on what you're trying to do. There are many ways to color background table values. Scan my earlier Tableau videos for different scenarios.
@RIVASCOSTAАй бұрын
Hi, thank you, I dont have the option "MAKEDATE", do you know if is it normal? If yes, is there any other formula?
@AnthonySmoakАй бұрын
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Ай бұрын
Super !! thx lots .. subscribed
@AnthonySmoakАй бұрын
Much appreciated!
@USA_to_Asia_in_2024Ай бұрын
Thank you Brother Smoak.
@AnthonySmoakАй бұрын
@@USA_to_Asia_in_2024 Thank you!
@DayJones-wb7igАй бұрын
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Ай бұрын
Curious: what would I do if the duration would be over 20 years? Would I still have to enter the # of days?
@jackiehay2914Ай бұрын
Hello! Where can I find the dataset to follow along? Could you please post it ?
@AnthonySmoakАй бұрын
@@jackiehay2914 Just do a Google search for "Tableau Superstore dataset". Some version of the file should be in multiple places.
@jackiehay291428 күн бұрын
@@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Ай бұрын
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Ай бұрын
Would better without the music - too distracting
@KennelRottweiler-HausАй бұрын
Waiting for Part 2
@calebbrady11Ай бұрын
Thank you, Anthony. Very helpful!
@AnthonySmoakАй бұрын
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.
@thehunter112 ай бұрын
We're having a serious PARTITIONING case here. You the truth man, thanks.
@AnthonySmoak2 ай бұрын
You're the real MVP, thanks for the comment!
@kailashsathia30802 ай бұрын
LOVE YOUR CONTENT. HELPED ME A TON AT WORK.
@AnthonySmoak2 ай бұрын
I'm very glad to hear that, thanks for sharing!
@Ivy_10572 ай бұрын
Thank you for the lesson! 👏
@AnthonySmoak2 ай бұрын
Thanks for leaving a comment!
@AllisonRosenbaum2 ай бұрын
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?
@anuskasarkar21832 ай бұрын
This is helpful but when I am downloading the extract from tableau server, I am getting duplicate values
@kennisrogers25852 ай бұрын
Hey, this was awesome :) i look forward to more guides
@AnthonySmoak2 ай бұрын
Thank you!
@tejeswarreddy62602 ай бұрын
How to create a connection when other user opens the Excel file , the data will refresh automatically, without prompting to authenticate to SQL
@mirrrvelll51642 ай бұрын
Great to follow this. I managed to do it/implement it into my report. Thanks and you got +1 new sub =)
@AnthonySmoak2 ай бұрын
Glad to hear it, thank you!
@mirrrvelll516419 күн бұрын
@@AnthonySmoak Ah one more question, for my confirmation, what about if I wanna apply the same logic on more than one page? Does it need to be created again with the same procedure/selections/bookmarks, or is there any kind of "copy-paste" behind it? Maybe in grouping and copying the selections, I saw it is possible to copy groups that you created before.
@AnthonySmoak18 күн бұрын
@@mirrrvelll5164 As far as I know you have to manually repeat the same process with new bookmarks. community.fabric.microsoft.com/t5/Desktop/Bookmarks-can-I-make-them-work-for-a-new-page-and-not-the/m-p/564714#M266488
@anthonylozito6912 ай бұрын
Helped!
@noelfrias23612 ай бұрын
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_prof862 ай бұрын
great videos !!!! Simple and Nice man !! tnx
@AnthonySmoak2 ай бұрын
Simple and nice is what I was aiming for, thank you!
@yassera.rahman41002 ай бұрын
Great explanation. Thanks
@AnthonySmoak2 ай бұрын
Thank you!
@fidi74002 ай бұрын
Thanks so much, you really helped me understanding grouping by and partition by. My lines of code now work as intended!
@AnthonySmoak2 ай бұрын
Fantastic, glad to hear that you learned something new!
@RamMukesh862 ай бұрын
We can use copy formatting from one worksheet to another worksheet for bar chart to save time😊
@filiporg5799Ай бұрын
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.
@aspirationalaudio40252 ай бұрын
Really Thank you for your explanation 😍😍 a New Like and subscription From Egypt 🤙
@AnthonySmoak2 ай бұрын
Thank you for supporting the channel!
@hameheroj40302 ай бұрын
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 :/
@AnthonySmoak2 ай бұрын
Glad to hear it!
@coreypea62252 ай бұрын
Thank you man, you are a lifesaver!
@AnthonySmoak2 ай бұрын
Thanks for the comment, much appreciated!
@jdwyer48512 ай бұрын
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.
@AnthonySmoak2 ай бұрын
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.
@jdwyer48512 ай бұрын
@@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Ай бұрын
@@jdwyer4851 I made a video exploring the MS Query approach. Thanks for the comment. kzfaq.info/get/bejne/aNWEYLOZzMmvkWw.htmlfeature=shared
@jdwyer4851Ай бұрын
@@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.