Validate Issue

Is anyone else having problems with the validate button? If I try to validate formulas using the validate button it gives me an error.

image.png image.png

But the validate button on the field does not give the error.

image.png

This started after one of the recent - refresh your browser we've updated Domo screens.

** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **

Best Answers

  • brycec
    brycec Coach
    Answer ✓

    I am running into the exact same error. I assume you are using the Group By tile when this occurs, not the Add Formula tile? I cannot tell from your screenshots because of how they are cropped. I ask because the Add Formula tile doesn't support aggregation functions, which MIN is. But when I tried that, it gave me the informative error of "Calculation Error : Aggregate functions are not allowed in this context: 'MIN'."

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!

  • AndreaHenderson
    AndreaHenderson Domo Product Manager
    Answer ✓

    Thanks for reporting this. One of the engineers on my team is working on it now.

    Domo Product Manager for Data Transformation (MagicETL)

Answers

  • brycec
    brycec Coach
    Answer ✓

    I am running into the exact same error. I assume you are using the Group By tile when this occurs, not the Add Formula tile? I cannot tell from your screenshots because of how they are cropped. I ask because the Add Formula tile doesn't support aggregation functions, which MIN is. But when I tried that, it gave me the informative error of "Calculation Error : Aggregate functions are not allowed in this context: 'MIN'."

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!

  • @brycec At the time, I wasn't paying close attention to when. But yes, the group by tile. I don't think the formula tile has given me any problems. I mocked-up the screenshot because my flow deals with patient fields. But even very simple formulas cause the error. I've started getting so used to it that I'm ignoring the validate button.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • AndreaHenderson
    AndreaHenderson Domo Product Manager
    Answer ✓

    Thanks for reporting this. One of the engineers on my team is working on it now.

    Domo Product Manager for Data Transformation (MagicETL)

  • @AndreaHenderson Thank you!

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • b_rad
    b_rad Contributor

    Looks like a bug in the new version. The validation fails but the calculation still works fine. It happens in the Analyzer as well (when you create beast mode calculations).

    Surprising how Domo missed it when they were testing before the release.

    Bharath.