How to Translate Tableau's Fixed function in Domo?

user04285
user04285
in Data Platform & Data Science

Hi, 

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!

Comments

  • Valiant
    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: https://community.tableau.com/thread/236716

     

    Hope that helps,

    Valiant

     

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

Categories