Great video. Question: can you please recommend a good book on tableau calculations. While I'm good at designing (thanks to ur book), I am still coming up short in the calculation department. Thanks again for the video
Joe from DC just last week, two Data Schoolers created a workbook of Tableau calcs. public.tableau.com/profile/fuadahmed#!/vizhome/TheTableauBookofCalcs_15670096188850/TitlePage
Andy Kriebel Thank you very much. Had an issue yesterday were the grand total was not working within the viz. (tableau version 2019.1.3) had to use this formula: If first = 0 then window_sum (xyz )end. Then table calc. That worked when I removed everything from the viz except the formula but it didn’t bring in the grand total on the grand total line like normal. Somethings shouldn’t be this difficult. Also the only video (which I’m thankful) on this subject doesn’t have any sound
Hi Andy & Team-- Great vid! But will you mind helping me out with a query? I'm currently using the "Order Date" from one of our data sources from our Server ...When I attempt to add the excel with the scaffold date, it doesn't allow me to join them....I'm stuck here.
Hey tim, I know I'm kinda late, but I was able to achieve this in excel by creating a "Date Table" sheet and putting in a date for every day for that fiscal year. You can probably use the autofill tool to do this quickly. I did this with some quarterly sales data and inputted every day of that quarter i.e (1/1/2021, next row 1/2/2021 ... all the way to 3/31/2021). Now you can use this in your "Columns" in Tableau and drag in your data into "rows".
Hello Andy
Great explanation.
How to include another dimension as a filter?
I've tried a few things but none working
Thanks
I just followed all the steps!
Great video.
Question: can you please recommend a good book on tableau calculations. While I'm good at designing (thanks to ur book), I am still coming up short in the calculation department. Thanks again for the video
Joe from DC just last week, two Data Schoolers created a workbook of Tableau calcs. public.tableau.com/profile/fuadahmed#!/vizhome/TheTableauBookofCalcs_15670096188850/TitlePage
Andy Kriebel
Thank you very much. Had an issue yesterday were the grand total was not working within the viz. (tableau version 2019.1.3) had to use this formula:
If first = 0 then window_sum (xyz )end. Then table calc. That worked when I removed everything from the viz except the formula but it didn’t bring in the grand total on the grand total line like normal. Somethings shouldn’t be this difficult. Also the only video (which I’m thankful) on this subject doesn’t have any sound
thank you for nice tutorial
Hi Andy & Team-- Great vid! But will you mind helping me out with a query? I'm currently using the "Order Date" from one of our data sources from our Server ...When I attempt to add the excel with the scaffold date, it doesn't allow me to join them....I'm stuck here.
how to select the date from the calendar to show upcoming event
Is that a question?
Could you do this with fiscal years? For example from the 6th April 2019 - 5th April 2020?
Hey tim, I know I'm kinda late, but I was able to achieve this in excel by creating a "Date Table" sheet and putting in a date for every day for that fiscal year. You can probably use the autofill tool to do this quickly. I did this with some quarterly sales data and inputted every day of that quarter i.e (1/1/2021, next row 1/2/2021 ... all the way to 3/31/2021). Now you can use this in your "Columns" in Tableau and drag in your data into "rows".
Is this applicable in excel worksheet? Any tips to be applied on excel
I don't know.
Can you please recommend a good book on tableau designing
The Makeover Monday book of course. 😊 bit.ly/MMtheBook