Showing posts with label table calculations. Show all posts
Showing posts with label table calculations. Show all posts

Table calculations



  table calculations are the calculations that are applied to the entire table in tableau while performing
 the table calculations we need to know two things.


              what type of calculations we are performing


   What type of calculation indicates the diff table calculations like diff from percent diff from ,
    percent of total extra.


              where we are performing the calculations



   Where we are performing the calculations is having two parts


                  1.addressing part


                  2.partitioning part



addressing options:



       the diff addressing options are available  in tableau are


                       Table across:

                                             If u performing the calculations across the table horizontally then
                                             such a kind of addressing is known as table across.

                        Table down
                                      If you are  performing the calculations down the table vertically
                                       then such a kind of addressing is known as table down.

                        Table across then down
                                 If you are performing the calculations across the table horizontally the
                                down the table vertically then such a kind of addressing is known as
                                 table across then down.
                        
                        pane across 
                               If you are performing the calculations across the pane horizontally then such
                               a kind of addressing  is known as pane across.
             
                        pane down

                                If you are performing the calculations down the pane vertically then such a kind
                              of addressing is known pane down.

                       pane across then down
                                 I f you are performing the calculations across the pane horizontally then down
                                 the pane vertically then such a kind of addressing is known as pane across then                                     down



       partitioning part

                    Difference from  

                                     difference from is mainly used to display the growth in between two values:

                      Percent diff from 
                                 percent difference from is the second way to find out the growth in                                                         tableau. percent diff from is the best way to find out raising growth of any                                            business as it gives the growth in terms of the percentage.

                    Percent from
                              percent from is mainly used to find out the absolute change in the tableau the                                          percent from calculation is similar like the percent different from it displays the                                  percentage of all the values by comparing with the required value.

                    Percent of total

                                   the percent of total calculation .this calculation is very important if you want to                                     find out each individual value control  on the whole.