How to Translate Tableau's Fixed function in Domo?

user04285

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!

BlueRooster

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.