GrantSmith Coach 
-
Re: Median Date
Another potential alternative is to convert your dates into unix timestamp (TO_TIMESTAMP) which would be a number, this would then allow you to run a median on the number and then just convert the me…2 -
Re: How to reduce Magic ETL run time
When I'm developing ETLs I like to be a teapot - Short and Stout. Short Reduce the dataset size to the smallest you need before doing any more processing. Have a filter tile be your first tile or use…1 -
Re: API string question
It appears to be an issue with the connector itself not sending the API token properly. You'll need to log a ticket with Domo support to have them look into it. You could attempt to leverage the JSON…1 -
Re: Sort Table based on What was first selected in Filter
You'd likely need to utilize an event on your drop down to store the order in which the values are selected and also handle it when a value is deselected. You could store it in a hidden input type in…1 -
Re: How to make the math right with variables as filter
Wrap your entire outer/first case statement in a SUM function and replace all SUM(`Budget`) with COALESCE(`Budget`,0). Do the same for Actual its doing the subtraction after all records have been add…1
