Calculated Columns - how to use them ?

[kalyan540]

Hi Community, @dosu , @rusackas , @mistercrunch

Need some references or documentation and Guidance on using "Calculated Columns", its limitations.
Tried adding few SQL statements, but ended up with errors 🙌

Thanks & Regards
Kalyan Talari

[dosubot[bot]]

For creating Calculated Columns in Apache Superset, you can use a variety of functions depending on the database engine you're working with. For example, if you're using the SQLite engine, you have access to mathematical functions like abs, ceil, floor, string functions like concat, length, and date/time functions like date, strftime ^[1].

Unfortunately, I couldn't find specific documentation or examples within the repository for creating and using Calculated Columns, nor details on their limitations or common errors. However, when writing SQL for Calculated Columns, ensure that your syntax matches the SQL dialect of your database engine, and check for any specific function support or limitations.

If you're encountering errors, double-check your SQL syntax and the compatibility of the functions you're using with your database engine.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}