Tableau Dates: Complete Introduction -Date Part vs Date Value, Discrete vs Continuous, common charts

Поділитися
Вставка
  • Опубліковано 26 лис 2024

КОМЕНТАРІ • 152

  • @ni12907
    @ni12907 3 роки тому +14

    Hi sqlbelle, I really want to thank you today for making these amazing tutorials and teaching us such valuable information. You videos contributed so much to me getting a new JOB as a DATA VISUALIZATION ANALYST in the midwest region in US. I hope to connect with you on LinkedIn. I went through all of your videos before my interview ❤️. Thanks again!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Wow, Nishi, that is amazing news! I am so happy for you! That is a wonderful news, thank you so much for sharing! :) And yes please do connect on LinkedIn!! 😊

    • @wandererlion2699
      @wandererlion2699 3 роки тому

      @@sqlbelle What is your linkedin profile name? Do you mind sharing? Thank you.

  • @DM-og1iy
    @DM-og1iy Рік тому

    Incredibly easy to follow/understand. I'm on the sideline waiting for on-going maintenance of a dashboard to be handed off to me, and needed a way to get up and running with the program --- this has been by far the best resource online to date. Thank you very much, and please keep up the great work!

  • @sarasong6019
    @sarasong6019 3 роки тому +4

    This is the most comprehensive explanation of dates of Tableau I ever saw. Thank you!

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you Sara, glad to hear you found it useful 🙂

  • @paragkar8885
    @paragkar8885 3 роки тому +1

    When I watch your videos, I can't stop getting amazed each time I do. Many thanks for all your efforts.

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you so much for your kind comment, Parag. Much appreciated!

  • @mensamapees4686
    @mensamapees4686 3 роки тому +1

    I wish I will never stop watching your videos. Your explanations are excellent. Please keep doing these videos. Thank You

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Mensa for your comment and support. Much appreciated.

  • @Tauhid214
    @Tauhid214 8 місяців тому

    You are a jam in presenting Tableau topics swallowable

  • @derekbelyea
    @derekbelyea 3 роки тому +1

    Very thorough exposition on a topic that is not immediately obvious to new Tableau developers.
    Looking forward to more like this one.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Derek!

  • @br31woodlands69
    @br31woodlands69 Рік тому

    Level of detail in this video is outstanding. Thank you.

  • @graceqin5024
    @graceqin5024 11 місяців тому

    This is a very helpful video. It explained to my confusion in a systematical way!
    Notes for myself:
    How to get just date instead of the modeled Year/Quarter/Month/Day?
    - right click and drag the pill
    - chose date (discrete)

  • @deepasarojam4425
    @deepasarojam4425 2 роки тому +1

    Awestruck!! I learned a lot from this series on Dates,. Thank you Donabel for posting these videos.

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      So glad to hear, Deepa :)

  • @ni12907
    @ni12907 3 роки тому +2

    I always click on like button before I start your video 👍👍👍

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Nishi! I hope you will find it informative 😀

  • @deepasarojam1433
    @deepasarojam1433 2 роки тому +1

    Thank you Donabel for this video. DATES was so confusing for me and this is a packed video helped me with the gap in my understanding. You really have a crisp way of teaching.

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you so much for sharing your feedback, Deepa! So happy to hear you found the video helpful :)

  • @rajeevguj
    @rajeevguj 3 роки тому +2

    Must watch for all. Got many things cleared. Thank you. God bless. Keep up good work.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Rajeev, I am so glad you found it useful! 😀

  • @vijayarjunwadkar
    @vijayarjunwadkar 3 роки тому +5

    Simply WOW! How I wish I could learn so much and so well about dates in Tableau before! Thanks a ton! Looking forward for many more such videos from you! Keep up the great work! 😊👍👏

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you Vijay, glad you found the video informative!

  • @gasundry12
    @gasundry12 Рік тому

    Excellent tutorial. Best clarification on date part vs date value.🎉🎉🎉

  • @SebAnt
    @SebAnt 2 роки тому

    Absolutely brilliant!! The analogy with the Lego parts and ball of yarn reinforces the concepts 👏🏼👏🏼

  • @englishladylady6919
    @englishladylady6919 3 роки тому +3

    Your explanation is enlightening me all the time. Best teacher . Thank you so much !

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Englishlady 🙂

  • @jagank7812
    @jagank7812 2 роки тому

    The Demonstration was just outstanding, thanks a lot for taking the time to make these concepts extremely easy for us to understand

  • @pavan3229583
    @pavan3229583 3 роки тому +1

    This is the one of the best video which gives beautiful explanation about the date part and date value which i have so confusion. Your explanation helped me a lot. Thanks for creating this tutorial. It helps me a lot.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Pavan! Glad to hear you found it helpful!

  • @b9821
    @b9821 3 роки тому +2

    DATEs in Tableau sometimes behaves unusual and developers should know how and learn the tricks to use it effectively...this is an awesome tutorials.. Definitely there is always a great take away from ur Vids...i have mostly viewd all of ur vids ..its a grt learning and a refresher too.. Plz keep sharing ur Data Adventures.. Arigatōgozaimashita 😊

    • @sqlbelle
      @sqlbelle  3 роки тому +3

      Hello Binod, thank you so much for your note!! I am so happy you found it to be a great refresher, and yes I agree that dates can get pretty confusing in Tableau especially if you are just starting out. Thank you for your support! 😀

    • @PatrickBateman12420
      @PatrickBateman12420 2 роки тому

      I agree on the awesomeness of the video. However, dates are tricky in programming languages e.g., Python or R as well.

  • @equiwave80
    @equiwave80 3 роки тому +1

    I am very thankful to have found your channel. Your videos are excellent for reinforcing the Tableau concepts especially tricky ones like Date fields.
    Words are not enough to appreciate your efforts for the Data Community!!! 👍👏👌

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you for such a generous and wonderful comment, Deepak. I appreciate it. I am happy you finding them helpful! I saw your posts on LinkedIn - they're very helpful. I look forward to learning more from you as well :)

  • @MissFSimoes
    @MissFSimoes 2 роки тому +1

    Thank you for sharing your extraordinary talent with us!! You're amazing!

  • @shraddhaw1537
    @shraddhaw1537 2 роки тому +1

    simply brilliant !!!! grateful that i found your videos; they're amazing..& so are you!!!!

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Shraddha! Glad you found them helpful!

  • @bhawnamongia4955
    @bhawnamongia4955 3 роки тому +1

    OMG such a thorough chapter...wonderful...God bless You 😃

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you Bhawna!

  • @brendensong8000
    @brendensong8000 3 роки тому +1

    Very clear and concise! Love your teaching and in-depth knowledge of the Tableau! Thank you for sharing!!!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Brenden!

  • @ashishroshan5946
    @ashishroshan5946 Рік тому

    Hi Sqlbelle,
    Thanks for such a descriptive video on dates in tableau.

  • @kumarshivam7137
    @kumarshivam7137 2 роки тому +1

    seriously literaly in love how u explain ..thank you so muchj

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Kumar!

  • @RamMukesh86
    @RamMukesh86 3 роки тому +1

    Awesome! Watching your videos on your Chanel is like preparing for interview. Anyone can crack the interview if watched all videos.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Mukesh. That would be wonderful if the videos helped in interviews 😀. Thank you for your support!

  • @eddyjo3259
    @eddyjo3259 3 роки тому +2

    This is again a valuable explanation.
    Thanks a lot Donabel !

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Eddy 😀

  • @piyushpathak7311
    @piyushpathak7311 3 роки тому +2

    It's very helpful mam keep uploading these type videos..

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Piyush!

  • @dxwallace55
    @dxwallace55 Рік тому

    Same comment as I gave you twice before, you explain things very clearly.........

  • @sowjanyakake5720
    @sowjanyakake5720 Рік тому +1

    Just Amazing!! The level of detail in each of the concepts is just crystal clear which builds confidence in beginners like me.. Thank you so much for the valuable content.

    • @sqlbelle
      @sqlbelle  Рік тому +1

      Thank you so much for your kind note Sowjanya! I appreciate it.

  • @anil_ind
    @anil_ind 3 роки тому +2

    Another excellent tutorial and very well explained. Thank you.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Anil! Happy to hear you found it helpful!

  • @jraj2380
    @jraj2380 2 роки тому

    Very nice video Mam.. clarified many of my doubts regarding date functions. Thank you so much for making very informative videos.

  • @ramyayellapu574
    @ramyayellapu574 Рік тому +1

    Your a Truly a good mentor. I really feel like putting a comment and appreciate you for your effort and knowledge sharing with us. You really stressed on many topics where many people doesn't stress much. I loved your playlist to get full in depth knowledge about tableau. I'm now so confident that i learnt many things which i'm not aware before. Your truly Amazing and sweet 💛

    • @sqlbelle
      @sqlbelle  Рік тому +1

      Thank you so much Ramya!

  • @phuong121288
    @phuong121288 3 роки тому +1

    Hi, I want to say thank you so much for this. Your tutorials are amazing.

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you for sharing your comment Phuong, I appreciate it. Glad to hear you found the video helpful.

  • @youmunna6452
    @youmunna6452 3 роки тому +1

    Loving your teaching and your favorite...

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you You! :)

  • @ushasuresh81
    @ushasuresh81 3 роки тому +1

    Yet another Very informative video about Tableau Dates... Thank you 😊

  • @dipankarbose4070
    @dipankarbose4070 3 роки тому +1

    Your videos are very informative...Looking forward to many more such videos from you... thank you so much...

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Dipankar, happy to hear you found the video informative!

  • @wandererlion2699
    @wandererlion2699 3 роки тому +1

    Thanks for your nice explanation of dates. You also have a beautiful voice. ❤️

  • @sherifsalem8097
    @sherifsalem8097 2 роки тому

    What a great explanation! Thanks a lot

  • @bharatkankate196
    @bharatkankate196 3 роки тому +1

    Great content with crystal clear explanation, keep posting more videos on tableau admin part also.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you! Glad to hear you found it helpful!

  • @kishoredubbasi9780
    @kishoredubbasi9780 3 роки тому +1

    WOW You really Awesome Teacher.... What i can give you....... I just watching full ads with out skipping for your channel support.....Thank you

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you so much Kishore. Really appreciate the kind note and thoughts :)

  • @agermoune
    @agermoune 3 роки тому +1

    Another great Video - glad I took time to watch it. There always new tips to learn from your channel! Keep it up

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you abderrahim, I am glad to hear you found some new tips 😀

  • @AdrianaPerez-ev5cj
    @AdrianaPerez-ev5cj 3 роки тому +1

    Excellent tutorial. I learned a lot. Thank you!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      I am so glad to hear you found it helpful, thank you Adriana!

  • @Data_Mom
    @Data_Mom 3 роки тому +1

    Super video and easy explanation. Thanks a ton for creating these awesome videos.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Pooja, glad you are finding them helpful!

  • @janagamasanthosh1087
    @janagamasanthosh1087 3 роки тому +2

    nice explaination lot of thanks...pls do more videos on scenario based interview questions in tableau...i will be wait for your videos...thank you

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Santhosh!

  • @aniketsawant4830
    @aniketsawant4830 3 роки тому +1

    Thank you for so much! Crisp and Clear!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Aniket!

  • @Ravit20
    @Ravit20 3 роки тому +2

    Very insightful 🙂

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Ravit! I like your new pic!

  • @peterparker4358
    @peterparker4358 3 роки тому +2

    Nice one ❤️ learned something new again today , will remeber always the difference between datepart and datevalue😁 love ur content always

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you, as always, Peter! 😀 Glad there was something new you got from this video :)

  • @Universe-xg7ou
    @Universe-xg7ou 3 роки тому +1

    Very informative presentation. Appreciate!! Thank you so much again!!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you, I am glad you found it informative!

  • @MrStark-zy6cd
    @MrStark-zy6cd 3 роки тому +1

    Thank you so much for your great work. A very detailed and informative video.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Mr Stark! Glad you found the video to be informative! 🙂

  • @johnm8342
    @johnm8342 Рік тому

    Thanks for showing the drop-down option on date... I'm so not used to using right click... is there an accessibility feature, just curious?

  • @rasikadhanapala5354
    @rasikadhanapala5354 2 роки тому

    Supper explanation. Thank you so much

  • @maseedilyas203
    @maseedilyas203 3 роки тому +2

    Been waiting for this video ❤️

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Maseed! 😀

  • @atifahmad8466
    @atifahmad8466 3 роки тому +1

    Hi
    Outstanding, the content you posted has been very helpful.
    Can you please make a video on SSO(single sign on) authentication for tableau server/online including active directory part as well.

  • @AhmerJamil
    @AhmerJamil 3 роки тому +1

    Amazing job done!!

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Ahmer!

  • @shubhampawar8506
    @shubhampawar8506 2 роки тому +1

    That's what I wanted 🙌...thanks a Lot ❤️🙏

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Shubham!

  • @tomix7777
    @tomix7777 2 роки тому

    Amazing video, as usual. Since I am working on a project that involved dates function I was wondering if I could as the following question.
    I have a data set that has daily apartment rental data that I would like to visualize by month. However, sometimes the dates of the daily rental will overlap the month. I am trying to plot total rented days during a given month that I obtain using DATEDIFF function that takes the difference between 'from date' and ‘to date’. The problem I run into is when I have two rental such as:
    - one from June 3rd to June 6th (3 days in total)
    - and the second rental from June 11th through July 18th (37 days in total). - this rental overlaps two months
    When I try to plot it as a line based on the ‘from date’ Tableau interprets it as 40 days of rental in July which looks silly on the chart. Would you know a solution to this problem?

  • @magnumbi8396
    @magnumbi8396 2 роки тому +1

    Fantastic lesson! Thx

  • @R.Beasley
    @R.Beasley 2 роки тому

    Hi, sqlbelle. Thanks for the tutorial. The FY for my company starts Dec 29th, and FM starts every 29th on the calendar. Is there a way for Tableau to recognize this and allow for a continuous FM or FY?

  • @milenaparra2363
    @milenaparra2363 2 роки тому

    Hi sqlbelle, wondering if you can help us how to create bucket of interbals of time. weeklyu, monthly, daily, quarterly and yearly? thanks in advance

  • @michafabich9213
    @michafabich9213 2 роки тому +1

    learnt a lot from this

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Michal.

  • @englishladylady6919
    @englishladylady6919 3 роки тому +1

    Thank you so much. Can we face cohort analysis in tableau certified associate exam?

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you for your support! Yes, there may be a question on cohorts where LODs may be asked.

  • @davidjackson7675
    @davidjackson7675 3 роки тому +1

    Thanks, that was really helpful. What is be Exact Date function for?

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      By default when you drag dates they will be aggregated to some degree, for example at the yearly level, the quarter, the month etc. The exact date is if you want to use or display the exact date as it appears in your data source

  • @rajashekarn2000
    @rajashekarn2000 3 роки тому +1

    Nice Explanation...Can you please make a video on Parameter action with user cases?

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you Rajashekar, I hope you found the video useful. And yes, one of the videos I plan to create is with parameters and parameter actions 🙂

  • @bozhou1454
    @bozhou1454 Рік тому

    16:21
    It looks like Tableau changed something. When right-click dragging 'order date' onto the view, the 'drop field' shows all the signs are the calendar signs, no more '#' sign and 'calendar+clock' sign.

  • @sumitchhabra2419
    @sumitchhabra2419 3 роки тому +1

    Hi,
    I love the way you explain stuff, just one request. Please include the file as well so that we can practice what you are teaching.

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      Thank you Sumit! I am organizing the files and will be posting them on my website as well as the descriptions of the videos.

    • @sumitchhabra2419
      @sumitchhabra2419 3 роки тому

      @@sqlbelle Thanks a lot for considering my request. 🙏

  • @CaribouDataScience
    @CaribouDataScience 2 роки тому

    Thanks was hellpful!!

  • @mazeenmuhammed
    @mazeenmuhammed 3 роки тому +1

    Hi Sqlbelle,
    I was trying to find out the names of the customer for each product with highest sales for that particular product. I wanted to display it as a label.
    I got the solution but i wanted to know a particular difference.
    calc field : [ max prod sale ]
    a)
    {FIXED [Prod]: MAX(
    {FIXED [Cust], [Prod]: SUM([total])}
    )}
    vs
    b)
    MAX( { FIXED [Cust], [Prod] : SUM( [total] ) } )
    when I use a) with
    {fixed prod : MAX(
    IIF({ FIXED [Cust], [Prod]: SUM([total]) } = [max prod sale],[Cust],NULL)
    )}
    i get the right answer but
    with b i get the wrong answer.
    could you tell me how are the two things different?

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Hello Mazeen,
      One difference I can see with your calculations is your use of MAX.
      In the first one, you are using a fixed MAX which means it will not be affected by your layout, dimensions, dimension filters, measure filters.
      The second one, you use the usual aggregate MAX() which follows Tableau's default behavior, so it could be affected by.
      Also the first one is the max per product, while b is the max of the subtotal by product and customer (so it's more granular. I assume this gives you a lower number?)
      Hope this helps.
      Donabel

  • @rxmendxmen567
    @rxmendxmen567 3 роки тому +1

    Can you also do a similar video about "Maps". I would especially be interested in spatial functions like buffer and distance and cool ways to apply them ! :)

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      That's a great idea! Our team had a project that focused on the mapping piece (and that was before the new features in the new version that could have been so handy then!). Thank you Simon 🙂

  • @maheshbarma
    @maheshbarma 3 роки тому +1

    really vary useful one. thank you

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Glad to hear, Mahesh! Thank you for your comment, much appreciated!

  • @havefundrawing
    @havefundrawing 3 роки тому +1

    Such a great explanation for dates! I always wondered if I used DATEDIFF to find a previous quarter, if tableau would pull all years with that quarter number. Now I know for sure it will. So to find data from the same quarter last year, do I just have to do 2 DATEDIFF calculation, first find the year difference and then find a quarter difference to ensure I’m only getting data from last year? Or is there a better way to do that?

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Hi! It may depend on how your data and visuals are structured. Table calculations may be another easy way to do it. You can use table calc functions (like LOOKUP) to look up past values and do another calculation (difference, % difference etc).
      If your data does have multiple fields with dates, then DATEDIFF can help. These are great questions and I have been thinking of adding a video with specifically these (YTD vs Last YTD, YoY, MoM etc)

    • @havefundrawing
      @havefundrawing 3 роки тому +1

      @@sqlbelle Actually I just double checked my workbook. It does pull the correct quarter even when I don't specify the year. So I guess DATEDIFF is smart enough to recognize the date value even though theoretically it only asks for date part.

    • @sqlbelle
      @sqlbelle  3 роки тому +2

      @@havefundrawing hmm, just be careful. It may be because you have another datepart for year. But datepart wont pull the datevalue. The behavior of your workbook may change depending on what's in your view.

    • @havefundrawing
      @havefundrawing 3 роки тому

      @@sqlbelle I just checked with superstore data it's the same result. I think DATEDIFF recognizes the value. I'm in accounting, so I always have calculated field for "PQ amount" and "PQPY amount". And my formula is DATEDIFF between the data date and the parameter of the current quarter, make the DATEDIFF based on quarter, either equals to 1 or 4 to get PQ or PQPY data.
      I remember now what tripped me up was one time I used DATEDIFF on year=1, thinking it'll give me PQPY, but it gave me the entire year regardless of the quarter I'm in. That part makes sense now that I watched your video. Still doesn't quite explain how it knows the correct quarter to pull though. But you're right, it's just something I have to always double check for surprising results.

  • @nikhithcheavi1665
    @nikhithcheavi1665 3 роки тому +1

    Hi,
    You made learning Tableau very easy. Thanks for that.
    I have a doubt. The weekly slope chart for Technology shows a downward trend, but when its rolled back up to the 'year', it shows an upward trend. How is it possible considering all these weeks sum up to make an year?
    Regards

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you for your kind comment, Nikhith. Regarding your question - please note that with a slope chart, we are not displaying a "trend" line. The slope chart simply retains the first point and last point and connects them with a straight line. The slope chart in this example does not sum up the totals. This is why we have to be careful when using the slope chart, and articulating what the chart is showing. It's really to show "where we started" and "where we are now" - just those two points and not the history in between. Does this explanation help?
      Here is another reference for slope chart if it's helpful: academy.datawrapper.de/article/152-how-to-create-a-slope-chart#:~:text=A%20slope%20chart%20(also%20called,end%20point%20of%20each%20line.

    • @nikhithcheavi1665
      @nikhithcheavi1665 3 роки тому

      @@sqlbelle Got it. Thanks a lot for clarifying.

  • @datafancy1361
    @datafancy1361 3 роки тому

    Really mind blowing !

  • @tableau179
    @tableau179 3 роки тому +1

    Thanks, sqlbelle - comprehensive as always. One thing that frustrates me is when I use the Datename function - whilst custom formatting dates - the viz is always alphabetically sorted - All Aprils followed by Augusts / Decembers etc. Any way round this? I typically use: DATENAME('month',[Date])+" "+STR(YEAR([Date])) - to return April 2019 (as an illustration)....

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Hello,
      One thing you can try is instead of doing the calculation, if possible, is to use the dates and use the custom formatting.
      For example:
      1. In a new worksheet, drag the date field. By default this gives you discrete date part.
      2. Click on the pill dropdown, and change this to month date value (should be the one that has the May 2015 example on the side)
      3. Click on the pill dropdown again, and change to discrete
      4. Click on the pill dropdown > Format .. and under Custom use something like "mmmm yy"
      Tableau will still see this field as a date and not a string, and will sort correctly. Please give this a try. I'd love to know if this will work for you.
      Donabel

    • @tableau179
      @tableau179 3 роки тому

      @@sqlbelle Thank you! Yes, I am aware of this option - but, what I should have mentioned is that this is part of a Period to Date aggregation parameter - Hence, I proceeded with the CF to return the dynamic "mmm-yy" which leads me to my dilemma - the year & quarterly calculations are perfect -pasting my calculations FYR - hope you can suggest some tweak for month return? Thanks!
      CASE [PTD]
      WHEN 'YTD' THEN STR(YEAR([Date]))
      WHEN 'QTD' THEN STR(YEAR([Date]))+ ' '+"Q" +DATENAME('quarter',[Date])
      when 'MTD' THEN DATENAME('month',[Date])+" "+STR(YEAR([Date]))
      END

    • @tableau179
      @tableau179 3 роки тому

      Was able to figure it out ==>LEFT(DATENAME('month',(IF [Parameter] THEN [Date] END)),3)+ ' ' +
      RIGHT(DATENAME('year', (IF [Parameter] THEN [Date] END)),2)

  • @monikareddy326
    @monikareddy326 3 роки тому +1

    I would like to calculate 60 day revenue from the date field present in dataset. Not last 60 days. For ex: I have two year of historical data (1997,1998). I would like to calculate 60 day rolling revenue. for every 60 days I want to calculate revenue. Please help me in finding the answer.

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Hello Monika - how are you planning to display this info? There may be a few ways to do this depending on the display or requirement.
      Core calculation may look like this:
      DATEADD('day', 60, [Order Date])
      You may be able to take advantage of:
      - table calculation, using moving calculation, possibly with 60 day partitions, or
      - LOD expression and basically summing up numbers that fall in the date range

  • @gudiatoka
    @gudiatoka 2 роки тому

    21:41 helper function

  • @nallelybalderasacatitla9102
    @nallelybalderasacatitla9102 3 роки тому +1

    you are awesome, thanks you so much

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Nallely :) I appreciate your comment!

  • @timothydrolet3041
    @timothydrolet3041 Рік тому

    Thanks!

  • @dragonmurali21
    @dragonmurali21 3 роки тому +1

    Hi Donabel Santos, you are amazing.. how to contact you..?

    • @sqlbelle
      @sqlbelle  3 роки тому +1

      Thank you Murali, happy to connect on LinkedIn. There should be a link in the About section.