1 Reply Latest reply on Nov 5, 2018 9:16 AM by Yuriy Fal

    Multiplication Table Calculation Help

    Nathan Bowling

      Hello everyone,

      I need help figuring out how to create a simple grade school level multiplication table.  This is easily done in Excel, but I can't get it working in Tableau.  Here is an example of what I'd like to recreate:

       

      Multiplcation Table Example.PNG

       

      My data set would only contain the "Data Value" of 10.  I then want an X and a Y axis to contain static values (that I can enter in Tableau that are not in my data) that I would multiply my "Data Value" by this type of formula:  Data Value*(x axis * y axis).  Any help would be greatly appreciated.  Thank you in advance!

        • 1. Re: Multiplication Table Calculation Help
          Yuriy Fal

          Hi Nathan,

           

          In Tableau, to draw Marks on a view,

          one needs Rows in the datasource.

           

          To draw a grid of 5 x 5 = 25 Marks,

          a datasource should be created

          that contains 25 rows. Or at least two ;-)

           

          The latter (creating a grid view using just a 2-row dataset)

          would require padding the data (a sort of data densification).

          I've used Bins for that. The values on the densified Marks

          in the padded table view are drawn using Table Calculations.

           

          Your single-value data set could be just a Parameter.

           

          Please find the attached as an example.

           

          Yours,

          Yuri