How to Translate Tableau's Fixed function in Domo?



I encounter a lot of Fixed function from Tableau when trying to translate it to Domo, but I can't seem to find any reference to such function here. One example is a measurement (let's call it 50-percentile Area) that looks like this in Tableau:

{ FIXED [Area group]: PERCENTILE( { FIXED [Building Code]:AVG([Number of Residents])},0.5)}

How should I translate this in Domo, please? 

Thanks a lot!


  • Valiant

    Since Domo is based on MySQL, most anything you can do there will work in Domo.


    The answer on this forum talks about how to relate a FIXED function to SQL. You may be able to follow a similar path:


    Hope that helps,



    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.