Best Of
Re: Getting Data
@Jazeppi if you need a quickstart on DDX Bricks, I made a YouTube tutorial with example bricks that show how you can retrieve data using Domo's SQL API in the brick:
ellibot
Re: Can you convert Date to Text in DOMO?
Is Domo interpreting your initial string as a date and the column is a timestamp data type?
There a function called STR_TO_DATE which will allow you to convert a string to a date type object based on the format string you pass in. Alternatively you can do TIMESTAMP() to convert your string to a timestamp since it's in the standard format.
Then you can use the DATE_FORMAT function on a date/timestamp field to return a string with the specific format you specify. You can read more on the format codes here:
Re: Can you convert Date to Text in DOMO?
You can do replace(`date_column`, 'T', ' ') with a space in between the final single quotes to indicate you want to replace all occurrance of 'T' with a space. This will also convert your date column to a string.
Alternatively, if you just want to remove the time part of datetime column, you can use the date function date(`date_column`) will only return the date part of the data.
jessdoe
Re: Unable to save the card with this beast mode.
What is the final goal of your analysis? Do you want to have a table that summaries all time goals by subcategory and question number? If so, do you want to add the all-time goals or average them?
I suggest converting each goal into a common format first, if there will be an aggregation across months.
However, if the analysis does not require aggregation, and only formatting is necessary, then the code you provided will work if you remove the AVG() functions from each of the when statements.
Alternatively, you can multiply the values by 1000 or 1,000,000, etc. depending on the format character, then have the table abbreviate the final number so that the K and M appear on the visual, but the numeric values are still preserved in the table. This is very useful if you will be exporting the information to a spreadsheet.
nmizzell
Re: Form Builder- Drop Down Capability
Yes, create a mega table that has your distinct values. In form builder, choose Add Lookup and select the mega table that you built as its source.
