4 Replies Latest reply: Oct 28, 2016 1:03 AM by Robert Mika RSS

    How to plot each table column as one bar in bar-chart?

    Daniel Eckert

      Hi guys,

       

      So let's say I have a table that looks as follows:

      has doghas cathas car
      101
      011
      011
      111

       

      What I want to create is a bar chart that plot's the sum of each column as a bar, i.e. the number of people who have a dog, cat or car. However, in reality i have a table with hundereds of columns in the table, and 10000's of rows. What I tried using is crosstable, However, I end up with a table that has millions of lines, and the dashboards has to load almost a minute before I can use it.

       

      Is there any more efficient way to do this?

       

      Thanks for your help!

      Cheers,

      Daniel