tag:blogger.com,1999:blog-3178813192704651028.post2693307907876827576..comments2024-03-28T17:52:37.818-04:00Comments on The Flerlage Twins: Analytics, Data Visualization, and Tableau: 5 Reasons to Use a Calendar/Date Table (Date Dimension) in TableauKen Flerlagehttp://www.blogger.com/profile/03698843288892226027noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-3178813192704651028.post-85211334447714170372023-07-05T21:57:33.552-04:002023-07-05T21:57:33.552-04:00Sorry, I found it. Here's the link for anyone ...Sorry, I found it. Here's the link for anyone not finding it in the article: https://docs.google.com/spreadsheets/d/10CLQGp57UlDkYM_eXEl2_qJMTYARjznD/edit#gid=1993513003Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-85418144377714876902023-07-05T21:53:33.745-04:002023-07-05T21:53:33.745-04:00Hi, Ken. I can't seem to find the google doc l...Hi, Ken. I can't seem to find the google doc links on the page at all. Are they still there? Cheers!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-30760111901690992032023-05-17T08:50:43.898-04:002023-05-17T08:50:43.898-04:00Seems to be working for me. Can you email me? I ca...Seems to be working for me. Can you email me? I can then send it via email. flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-52442167640630064952023-05-17T08:11:34.589-04:002023-05-17T08:11:34.589-04:00Can you republish then calendar data sheet? For so...Can you republish then calendar data sheet? For some reason the google docs link won’t open.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-8464227141280482552023-04-18T17:32:10.114-04:002023-04-18T17:32:10.114-04:00Well that's great to hear!! I'm glad Googl...Well that's great to hear!! I'm glad Google is leading you here. Performance for a calendar table should be quite good since it's a very simple join. Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-4741870676313920982023-04-18T13:48:41.934-04:002023-04-18T13:48:41.934-04:00Hi Ken, this is the second time this week that a g...Hi Ken, this is the second time this week that a google search has landed me on your site...so thank you for knowing what I need before I do! The tableau person before me used a custom scaffolding sql query in all of our dashboards and I have a hunch that this is the reason our extracts take longer to refresh. Before I go down the path of working on a calendar table to replace our scaffolding, how do you find the performance is with the calendar table join?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-77770093912801497722023-01-19T14:01:29.143-05:002023-01-19T14:01:29.143-05:00Hmmm. That could be tricky. Admittedly, I don'...Hmmm. That could be tricky. Admittedly, I don't have a good solution for that off the top of my head. Would be a great question to ask on the Tableau Community Forums.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-51167349538333756292023-01-19T12:49:50.327-05:002023-01-19T12:49:50.327-05:00Hi Ken, this was great information! As a former Po...Hi Ken, this was great information! As a former Power BI user, this makes a lot of sense to me. One of the things I'm struggling with that I didn't see addressed here is how to do these calculations when the start and end dates are 2 separate fields in the data. For example, Order Date and a Ship Date are separate columns, and we need to calculate the non-holiday weekdays between the two dates for each row/order.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-42344837883996375412022-12-02T10:52:09.787-05:002022-12-02T10:52:09.787-05:00Search the article for Mubin M. Shaikh and you'...Search the article for Mubin M. Shaikh and you'll find the paragraph--sorry, it's a bit buried.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-38130635426603259582022-12-01T18:56:44.061-05:002022-12-01T18:56:44.061-05:00"I’ll share a resource later in this blog tha..."I’ll share a resource later in this blog that has over 50 fields and contains virtually anything you’d ever want to know about a date." Did I miss it in the article?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-84848211889054574232022-05-05T10:35:07.337-04:002022-05-05T10:35:07.337-04:00This old Power BI user agrees with you. It's t...This old Power BI user agrees with you. It's taking me some time to figure out how to use a date dim table correctly with Tableau. The blog post is extremely helpful as I learn. Thank you!Nate Laningnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-27907490495838238772021-12-21T20:14:40.266-05:002021-12-21T20:14:40.266-05:00You could build one in Excel, but the advantage of...You could build one in Excel, but the advantage of having it in the database is that others can use it as well. Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-16838631534468418112021-12-21T05:20:16.443-05:002021-12-21T05:20:16.443-05:00Hi, Ken Amazing information! I am an old power BI ...Hi, Ken Amazing information! I am an old power BI user and used to have a calendar table available at all times. Now since I moved to Tableau I have not seen anyone use it. A couple of questions. <br />Can I build a calendar table in Excel and use that in tableau? <br />Should I include calculations on the table or is this table just for helping out in calculations later? <br /><br />Thanks and again amazing information! Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-6832685796037190772021-11-09T14:17:26.805-05:002021-11-09T14:17:26.805-05:00Yes, I can definitely see how that would be a chal...Yes, I can definitely see how that would be a challenge. One thing I like to do is put all of the date fields into their own folder in the Tableau data source--that way, they can just collapse the folder. And, of course, as people are building data sources, they can hide the fields they don't need. Finally, you could always create a database view that includes just the heavily used fields--by doing that, you can ensure you have all the fields in the database, in case they are ever needed, but most of the time, people will just use the stripped down view.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-77085425257687221392021-11-09T09:32:25.247-05:002021-11-09T09:32:25.247-05:00This is a great article, Ken. Our team builds out ...This is a great article, Ken. Our team builds out Tableau data sources and publishes them to Tableau Server for our business analysts to use. One common complaint we have heard from them is that the addition of all the attributes from these date dimensions "is too confusing" and they prefer to create calculations based on the date field. <br /><br />We're trying to strike a balance by still exposing some of those "extra" date dimension date type fields (ex. Sales Quarter Start Date or Fiscal Period End Date). This provides them some of those extra value fields, but not an overload of information.Brian Brookshttps://www.blogger.com/profile/02069309015361573181noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-50116777620261992282021-11-01T14:10:29.393-04:002021-11-01T14:10:29.393-04:00I do not, but I'd assume it would be pretty si...I do not, but I'd assume it would be pretty similar to this. You might want to search for something like "MySQL date dimension script".Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-40355352117855954552021-11-01T13:38:10.351-04:002021-11-01T13:38:10.351-04:00Do you have the calendar table code for MySQL? It&...Do you have the calendar table code for MySQL? It'll help me streamline the Tableau calculations.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-33267003099632725692021-10-20T08:36:57.697-04:002021-10-20T08:36:57.697-04:00Fantastic!Fantastic!Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-17525346344096795432021-10-19T17:31:44.746-04:002021-10-19T17:31:44.746-04:00Amazing work again, thank you for being awesome.
I...Amazing work again, thank you for being awesome.<br />I just created a date label for all periods TW, LW, PW, MTD, QTD,YTD TWLY, LWLY etc<br />These serve me well in calcs and just as labels to show im going in right direction.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-66781216199389852532021-10-18T10:23:29.962-04:002021-10-18T10:23:29.962-04:00Yes! Once you have the date dimension and get in t...Yes! Once you have the date dimension and get in the habit of including it, so many new use cases emerge.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-44458643179399907462021-10-18T09:56:40.128-04:002021-10-18T09:56:40.128-04:00I also use date dimensions to flag moving date ran...I also use date dimensions to flag moving date ranges (e.g. YTD for the current and prior fiscals years to make year-over-year calcs update automatically). Another great article. Thanks Ken. dwhittenberghttps://www.blogger.com/profile/04660395325283892293noreply@blogger.com