Best Of
Re: What is the format for the substring function?
This KB article may be of help where it outlines the different functions and their formats:
SUBSTRING(`Column`,[START POSITION],[NUMBER OF CHARACTERS TO EXTRACT])
Re: Domo API to MS-SQL
@ArborRose - I have an idea for you that may make your life easier.
Domo has an ODBC driver. I'm betting you could install that on the machine your SQL server sits on then configure a linked server on the SQL Server side. That way, you can query and view Domo data live using standard MS SQL. I havent done it myself, but we used to use MS SQL before Domo and if some external datasource had ODBC drivers, we'd link them directly into our SQL Server to make it much easier on ourselves. We could then just schedule a SQL server job to select data out of a given source and upsert it into a SQL table.
ODBC Driver:
Creating a linked server in MSSQL to an ODBC datasource:
DomoDork
Re: Store values from daily average
Hi Grant!
I just stumbled accross this as well! That seems to be new….Looks like this is doing the trick. I set it now to update all 15 minutes and store it per minute…..
Thanks much again!
Caroline
Re: Beastmode subtotal not calculating correctly
@Anna_Otake You're definitely on the right track. The only changes I recommend are moving the COUNT outside the case statement and removing the ELSE 0 clause. Your formulas should all be formatted like this:
count(case when `FY Order` = 0 then `cm_pla` end)
Re: Domo Search API?
@marcel_luthi Thanks. I figured as much. It's not a documented API endpoint so I figured why not try to give it a shot and see if it works anyway. It's unfortunate because had it worked, it would have saved me so much time since I wouldn't have to go off and develop a bunch of ETL's bringing a bunch of governance data together to mimic a similar style search thats already built into Domo. All I wanted was that sweet JSON response data. It had everything I needed in one big ole object that I could've parsed through to display on my Domo brick.
Ah well, at least we tried :D
Have a wonderful day!
DomoDork