Create column in table

[Tarsis Azevedo]

I want to modify my table on superset by creating a new column with values based in another column in this same table.

What I have to do: put a sql query to do this in Sql field at table Detail tab or create a new column and put the insert sql in Expression input?

Thanks!

[Nitin Dhawan]

Hi Tarsis,

Quick answer

If the column will be used as a Dimension, then add it in List Table Column.

If the column will be used as a Metric, then add it in List Sql Metric.

Both options are in Sources >> Tables >> Edit <some table>

Helpful info about Dimensions and Metrics.

Dimension means something that you cut or group data by - example: gender, product category, age bucket, etc.

Metric means something that you measure. Example: Count of pages hits, Count distinct users, Count distinct users divided by Count of page hits. 

Cheers,

-Nitin

--
You received this message because you are subscribed to the Google Groups "airbnb_superset" group.
To unsubscribe from this group and stop receiving emails from it, send an email to airbnb_supers...@googlegroups.com.
To post to this group, send email to airbnb_...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/airbnb_superset/5b4c7c8d-caee-403d-8259-540fef904eef%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.