0

Create a Text Column

How do I create a text column which shows up a dimension in the discover?

I am also curious on different methods that can be used to achieve this. 

 

Use Case: I want to use these text columns in the matrix grid because it's easier for me to format, align and maintain consistency.

 

Thanks,

Rajesh

2 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 6 mths ago
    • Reported - view

    Hi  ,

    Any text column in the underlying data tables will show up as a dimension / hierarchy in your model provided it is identified as such (i.e. first checkbox is checked in the model definition). 

    If you want to create a new column, you can do this either by creating the calculation explicitly in the Model  Data Flow, if it has one (calculated columns), virtually in the Model Definition (Virtual Calculations), or dynamically in Discover by right clicking on the hierarchy  (for simple calculations, like the first character or combining columns) or Formulate (Custom Columns) for more complex multi column calculations.

    You may also want to investigate  a text column defined as a Measure using Text Aggregation.

    Hope that helps.

    Ian

      • Senior Director of Product
      • Ian_Macdonald
      • 6 mths ago
      • Reported - view

       If you mean a grid as a set of columns, change the grid type from Matrix to Column.

Content aside

  • Status Answered
  • 6 mths agoLast active
  • 2Replies
  • 82Views
  • 2 Following