ArborRose Coach 
-
Re: DOMO SQL - Formula
The NaN means "not a number". LIkely due to a divide by zero issue. Maybe try catching the condition SELECT *, CASE WHEN sum("AD_IMPRESSIONS") IS NULL OR sum("AD_IMPRESSIONS&…1 -
Re: Issue with using calculated field in "Values" section with Pivot Table
Are you sure this isn't caused by the data you are using and the fields that are presented in rows and columns?1 -
Re: Need help writing a Beastmode
The formula as Grant has typed it looks correct. Assuming your typing exactly matches the condition logic. Using a fake dataset: hospital_name current_balance financial_class aging_group Central Hosp…1 -
Re: Why is my data not being refreshed?
On your data flow, check the schedule to make sure it is scheduled. It may be set to manual, which requires manually triggering. If the log shows the data flow ran recently but you still don't have d…2 -
Re: Why is my data not being refreshed?
You could… Test the API Outside of Domo . Run the API using something like Postman or cURL to make sure its givng back data. If the API outside of Domo also shows no data, it’s an issue with the API …2
