How to Scaffold Dates to Create a Yearly Calendar

Рет қаралды 11,678

Күн бұрын

Пікірлер: 15

@andremoraes1467 Жыл бұрын

Hello Andy Great explanation. How to include another dimension as a filter? I've tried a few things but none working Thanks

@bornofdata 4 жыл бұрын

I just followed all the steps!

@jihyunpark1404 4 жыл бұрын

thank you for nice tutorial

@joefromdc 5 жыл бұрын

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

@vizwiz 5 жыл бұрын

Joe from DC just last week, two Data Schoolers created a workbook of Tableau calcs. public.tableau.com/profile/fuadahmed#!/vizhome/TheTableauBookofCalcs_15670096188850/TitlePage

@joefromdc 5 жыл бұрын

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

@bpcx21 5 жыл бұрын

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.

@nihalomar289 2 жыл бұрын

Is this applicable in excel worksheet? Any tips to be applied on excel

@vizwiz 2 жыл бұрын

I don't know.

@Dragz672 4 жыл бұрын

Could you do this with fiscal years? For example from the 6th April 2019 - 5th April 2020?

@trentonmoore5850 3 жыл бұрын

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".