Where are the Magic ETL Formula Editor / Add Formula functions documented?

BSovers
BSovers Member
edited March 2024 in Magic ETL

I'm looking for actual documentation of the DATE_FORMAT, DATE_TRUNC, and TIMESTAMP_TRUNC functions.

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    Since the formulas are SQL based, they aren't all documented specifically for Domo, or if they are, I haven't seen it, lol. I'll usually Google the name of the formula and Domo, for example: DATE_FORMAT Domo, and if there is something in the knowledge base, that will turn it up. Here's an article on DATE_FORMAT

    https://domo-support.domo.com/s/article/360043429953?language=en_US

    When that doesn't work, I'll Google the name of the formula and SQL.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    Since the formulas are SQL based, they aren't all documented specifically for Domo, or if they are, I haven't seen it, lol. I'll usually Google the name of the formula and Domo, for example: DATE_FORMAT Domo, and if there is something in the knowledge base, that will turn it up. Here's an article on DATE_FORMAT

    https://domo-support.domo.com/s/article/360043429953?language=en_US

    When that doesn't work, I'll Google the name of the formula and SQL.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • rco
    rco Domo Employee

    There's a button here in the formula editor to expand it:

    image.png

    Clicking it shows you this editor, which has a searchable function list and documentation:

    image.png

    There's also this support article.

    Though as of this writing that article does not stay up-to-date automatically with documentation changes or additions, so I'd recommend the docs in the expanded editor.

    Randall Oveson <randall.oveson@domo.com>

Categories