6 Replies Latest reply on Aug 10, 2017 6:29 AM by Jay Morehart

    How to visualize the data that have only dimensions

    SHIHO KOSONE

      Hi,

       

      I have created a matrix table(Attachment   Tableau ver.10.1).

      How to visualize the data that have only dimensions
      This table have satisfied the requirements, but it's too simple.
      I'd like to improve this sheet more stylish.
      Could you tell me how to visualize tha data that have many dimensions?
      There is NO measure in real data(only record count) and I can't think of anything better except for matrix table.
      If you have any idea to improve this sheet, please tell me.

       

      Shiho

        • 1. Re: How to visualize the data that have only dimensions
          John Sobczak

          You can always create measures from your dimensions such as datediff between two date fields (returns an integer value) or count of a dimension value.

          1 of 1 people found this helpful
          • 2. Re: How to visualize the data that have only dimensions
            Simon Runc

            hi Shinho,

             

            It all depends on the purpose of the Viz, the audience...etc. Sometimes it's not  appropriate (or required) to make something "all singing and dancing" if the requirement is just to convey information in an effective way.

             

            That said I think the below take on your Viz is a little quicker to ingest

             

             

            I think the Filled/Unfilled shapes give a better (quick) view on the coverage, and I've also used a colour scale here. On the colours....as the Ship Mode goes "better to worse" it might be useful to visually indicate this...however in your real world example if the dimension (being represented by Ship Mode here) has no "good to bad" relationship it might not be appropriate to add colour (I try and only add extra colours, if it means something and/or aids understanding). Alternatively if that dimension has a "natural" colour (eg. if they were brands) using the Brand colour for each one would aid the reading.

             

            Hope that helps

            2 of 2 people found this helpful
            • 3. Re: How to visualize the data that have only dimensions
              Jay Morehart

              Countd() is your friend. Number of records often works, but I prefer Count Distinct as I explicitly know what the number represents, it also allows you to count things above the row level, for example, how many sub-categories are in each category, or which sub-category has the most products

              if you create a calculated field (or use number of records): Number of orders = Countd([order id]), we can use the quick table calc: percent of total to get something like:

               

               

              I work with several datasources that are dimension-heavy/only. There really is no limit to what you can do with just dimensions, you just have to create some measures first (I usually do this first and then publish a datasource to server with my calculated measures). I have attached a workbook with some other viz ideas/starters

               

              Hope this helps!!

              • 4. Re: How to visualize the data that have only dimensions
                Shawn Wallwork

                I've spent the last month working with dimension only datasets. It is interesting how much you can get out of them. And yes COUNTD() is your friend.

                 

                --Shawn

                • 5. Re: How to visualize the data that have only dimensions
                  SHIHO KOSONE

                  Thank you so much for your reply.

                  I know COUNTD() and DATEDIFF(), but I'd like some advice about how to visualize data only dimension, not how to create measure.

                  For example, Loliop chart seems to be more stylish than Bar chart.

                  Just like that, I'd like to make this matrix table more stylish.

                  • 6. Re: How to visualize the data that have only dimensions
                    Jay Morehart

                    If you want to keep the matrix table, but make it have more visual impact, play around with size, shape and color, for example, assuming the emphasis is on points that have more than 100 records ("A" in your calculation 2) then you could do something like this:

                    Since we don't care about about items where records<100 I have made them smaller and "grayed out", In this case it makes it very easy to see what the prominent ship modes are.

                     

                    check out Shape Properties  for how to add custom shapes (I grabbed a set of 1000 shapes a few weeks ago and sorted them in to folders so I would have some more options with out searching them out for a specific report)

                     

                    Hope this helps!

                     

                    EDIT: typos