0 Replies Latest reply on Nov 20, 2017 11:05 PM by Avinash Reddy Kovvuri

    How to get a Similar Fibanocci Sequence in Tableau ? #Tables #calculated Field

    Avinash Reddy Kovvuri

      I am doing a Employee Training Analysis . Here is a trend pattern I want to show in a output

       

                                                       Q1                      Q2            Q3             Q4

      Training                                    8                          6               9                12 

      0-3 Months                               7                          12           14                18

      3-6 Months                              9                            7             9                  5

      6-9 Months                              4                            3            4                   1   

      9-12 Months                            8                            8             5                  14

      >12 Months                             8                           3              15                18                                                                                                                                     

      At the Initial  stage an employee will be in training phase later he moves to 0-3 months in 2nd Quarter and so on he will pass to 3-9  in Q3          8 - 12 - 9 - 5  Similarly we can 7 -7-7-14 ; 9-3-5-18

      I need to create a bar plot showing the how the employee performance charges has he moves through Quarters and  Months

      I can write an if loop - Calculated Field but i don't now how tableau takes this data

      In C it goes by Matrix we can write  i[1,1][2,3]  in loop

      Can any one give some idea how to proceed with this issue ?