1 Reply Latest reply on Sep 30, 2016 12:25 PM by Shinichiro Murakami

    Square table column *, not dividing by values.

    Guilherme Leitão

      Hello,

       

      I'm making a square table.

      (UFXNOME_CELULA)

       

      squaretable.png

       

      I don't know why, but that's not what I imagine what would happen.

      There are 5 possible values in the column (Nome_celula) but I don't know why tableau is making them one column named * and not put the 5 columns I want it to divide.

      My data base is based on a Oracle SQL that return 8 columns, and I have 1 calculated column (TAXA).

      Columns from DATA_BASE

      IND (ABC) - MES (DATE) - NUM(number)  - DEN(Number) - SEG(ABC) - UF(ABC) - NOME_CELULA(ABC) - REGIAO(ABC)-  TAXA(CALCULATED FIELD)

      TAXA = NUM/DEN

       

      Does anyone know why tableau is uniting my NOME_CELULA in only 1 column instead of dividing its values?
      Does anyone know how can I make it separate my values?