4 Replies Latest reply on Jul 23, 2018 7:08 AM by Sebastian Sofariu

    What does an asterisk "*" mean ?

    Kshitiz Mahajan

      I am using 3 data sources(D1, D2, D3) to build relationship on the basis of ID's keeping D2 as Primary data source. The date values that are coming from my secondary data source are showing up as an asterisk "*" instead of my actual data.

       

      Can anyone tell me where is the issue? Is there any work around to it?

        • 1. Re: What does an asterisk "*" mean ?
          Don Wise

          Hello,

           

          From the Knowledge Base:  The asterisk is actually a visual indicator of a special type of Null value that occurs when there are multiple members that apply to the mark.

           

          Meaning, you have multiple data values and Tableau doesn't know which to display.

           

          Please see the following to help you along: Troubleshoot Data Blending

           

          Thanks, Don

           

          If this resolves your question, please mark it as correct so that others may find it useful in the future.

          • 2. Re: What does an asterisk "*" mean ?
            Jim Dehner

            Hi

            sounds like you blended the data - the * indicate there are multiple date records instead of a unique value

             

            don't know your data so it is hard to tell what to do - could be restructuring the data or using connecting with a join would work better

            Jim

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

            • 3. Re: What does an asterisk "*" mean ?
              Mahfooj Khan

              Hi,

               

              I guess the granularity of each data source is different that's the reason when you're using any data field from secondary data sources its returning "*". You need to aggregate your data sources and make sure level of detail  of each source should be same then you'll get the proper result. Instead of blending you may try with joining data sources and check.

               

              Mahfooj

              • 4. Re: What does an asterisk "*" mean ?
                Sebastian Sofariu

                Hi Kshitiz,

                 

                Typically, when there are multiple matching value in the secondary data source for each mark in the primary data source, asterisks in the sheet are displayed.

                 

                You can avoid asterisks in the sheet by making sure that there is only one matching value in the secondary data source for each mark in the primary data source.

                 

                The article below document when asterisks are displayed in the sheet and how to resolve asterisks in the sheet

                 

                Hope this help.

                 

                Thanks