7 Replies Latest reply on Feb 26, 2018 9:22 AM by Diogo Braga

    Marks label not appearing

    Diogo Braga
    Diogo Braga Feb 20, 2018 2:32 PM

      Labels should show for 2018-2019 Current Week ( Week 8) and 2017-2018 Current Week (Week 8) and Week 39. It shows for some grades but not all. Allow labels to overlap other marks is selected.

       

       

       

      2018-02-20_1727.png

        • 1. Re: Marks label not appearing
          Joe Oppelt
          Joe Oppelt Ambassador Feb 20, 2018 3:08 PM (in response to Diogo Braga)

          I looked at the settings at the level of "ALL" marks, and no options were selected for labels:

           

           

          Not Line Ends, or Highlighted, etc.  Once I clicked ALL in there, all your marks showed up.  Give it a try.

          • 2. Re: Marks label not appearing
            Diogo Braga
            Diogo Braga Feb 20, 2018 3:39 PM (in response to Joe Oppelt)

            I found out that the issue is not on marks label, 2 calculations are returning Null for some grades hence no label. Let me know if you have any feedback.

             

            Week 39

            IF MIN(DATEPART('week', [Apptime]))=39 THEN [Application 2017-2018] END

             

            2017-2018 Current Week

            if min([Week])=min([Newest Week] )

            then window_sum(COUNTD([Application 2017-2018d]),first(),0) end

            • 3. Re: Marks label not appearing
              Zhouyi Zhang
              Zhouyi Zhang Ambassador Feb 20, 2018 4:42 PM (in response to Diogo Braga)

              Hi, Diogo

               

              Since some of the week, there is no data for a certain grade, the MIN(DATEPART('week', [Apptime])) will return nothing.

               

              So I will suggest to make change to your calculation of week39 as shown below

               

               

              Hope this helps

               

              ZZ

              1 of 1 people found this helpful
              • 4. Re: Marks label not appearing
                Diogo Braga
                Diogo Braga Feb 22, 2018 7:14 AM (in response to Zhouyi Zhang)

                Thank you very much! Why INDEX()=39 shows Week 40?! I checked, and INDEX()=38 shows Week 39.

                It works for my purpose, but I am just wondering the reason, and to learn more about INDEX() .

                Thank you!

                 

                2018-02-22_1012.png

                • 5. Re: Marks label not appearing
                  Joe Oppelt
                  Joe Oppelt Ambassador Feb 22, 2018 8:12 AM (in response to Diogo Braga)

                  Diogo -- There is no Week36 data on the sheet.

                   

                  INDEX() is a value that shows the position of each mark in the table.  You have all weeks up through week 35 in your data, but there is nothing for week 36.  So there are 35 marks from week 1 through week 35, and the INDEX and Week Number match for those weeks.  The next position in the table, index=36, has week 37 data because there is no week 36 data.  INDEX and week number will no longer match from week 37 forward because of this.

                   

                  Create this calc:

                   

                  //[INDEX]

                  INDEX()


                  Then put it in tooltips.  You can see the value of INDEX as you scroll across the line.  By the time you get to week 51, INDEX is only 48, so other weeks are missing in there as well.

                   

                  I find this [INDEX] calc extremely helpful when I am messing with table calcs.  I use it to make sure I am walking the table in the order I need when I do my table calc settings.

                  • 6. Re: Marks label not appearing
                    Diogo Braga
                    Diogo Braga Feb 22, 2018 8:33 AM (in response to Joe Oppelt)

                    Thank you for the explanation.

                     

                    I foresee some challenges in using INDEX() in my situation. The real dataset has 80+ schools and not all of them receive applications every single week. The goal is really to show the application running total at Week 39.

                     

                    I am thinking maybe I should join my dataset with a calendar table with every date of the years 2016-2017-2018-2019 to create new records for the missing dates. I have a feeling this would be better done outside of Tableau, maybe Maestro in the near future or any other data prepping tool.

                     

                    Let me know if you have any suggestions! Thank you!

                    • 7. Re: Marks label not appearing
                      Diogo Braga
                      Diogo Braga Feb 26, 2018 9:22 AM (in response to Diogo Braga)

                      Hey Joe Oppelt ,

                       

                      Let me know if you have any feedback on this. In regards to my last comment here, I learned that dataset missing dates will show if I click on 'Show Missing Values,' however, I can't get them sorted properly.

                       

                      I am asking this here: Create Dates in Tableau

                       

                      Hope you can help. Thank you!