1 Reply Latest reply on Apr 19, 2018 1:40 AM by kumar bharat

    how to create a histogram for 100+ columns with different bin automatically

    Nakachari nakachari

      Hi,

       

      I have a file that has 100 variables as column. I am trying to plot the histogram for each variable. Each column has different distribution. Reading through blogs, I could find that I can manually create bins by right clicking the measure. But since I have 100+ variables this method is not feasible for me. Is there a way to plot histogram of all these columns in different page or same page(stacked) with different bin distribution without manually creating these bins? Any links to tutorial or blogs will be very helpful as well.

       

      The format of the file I have is something like this:

       

      Var1     Var2     Var3     Var4     Var5..................Var100

      0           100     0.1          1          4                         9

      1           500     0.5          0          5                         9

      0           320     0.8          1          9                         9

      0           100     0.2          0          4                         9

      1           500     0.9          1          7                         9

      0           900     0.01          1        10                       9