ArborRose Coach

You should be able to do a calculated field such as CASE when City like '%New York%' then 'New York' when City like '%San Diego%' then 'San Diego' when City like '%San Francisco%' then 'San Francisco' when City like '%Boston%' then 'Boston' when City like '%Topeka%' then 'Topeka' end or CASE when INSTR(City,'New York')>0…

Yes, there is a way to split up timed sections and append. You can import via workbench, or connect to your data with an api. Create smaller datasets such as data_yr_2021, data_yr_2022, data_qtr1, data_qtr2, etc. Then create a workflow and use the append tile to append the datasets. That way, you can pull previous years…

You can create a custom calculated field based on programmed condition. The field could handle the conditional by adding or subtracting from the current date. Such as CASE WHEN campaign_to_date > 2/4/2023 and campaign_to_date < current_date() THEN 1 ELSE 0 END. Then use that as a filter to display when calculated field = 1.

An “api” is a programming interface. Think of it as a program that sits waiting to give you information. When your system contacts their api, your request is asking for updated information. The api responds with the information requested Its appears the usps api is communicating with XML. XML is a mark-up tagged language.…

I use json oAuth connectors. Within the settings configuration there is a section for "Parsing." You can select one of the nested branch heading and expand it to create a dataset based specifically on that branch. For example, one of my branches holds "items". Expanding items creates a schema of columns that are the…

Perhaps this thread will help. https://dojo.domo.com/main/discussion/43640/automatically-export-dataset-from-domo

I had a situation where I needed to purge/truncate and I couldn't figure a way in Domo. I ended up creating a dataset using mysql dataflow where the logic creates a B dataset based on A. The source dataset is never accessed, the output from the mysql becomes the source.

I would look into creating a custom column {formula} with the condition you need. The resulting column can then be used as the color condition. Thus, the new column would show when it dips below or rises above, and the color settings would react to that.

https://developer.domo.com/docs/authentication/overview-4

Looks like you need the client ID and secret. Go to the site for "developer.domo.com". Configure a client for the app and it will produce your id and secret values.

Usando la lógica del modo bestia como CASO CUANDO {condición} ENTONCES X DE LO CONTRARIO Y CUANDO {condición2} ENTONCES X2 DE LO CONTRARIO Y2 FIN. Los agregados como sum se pueden aplicar para sumar diferentes columnas.

Domo has a command line interface (CLI) which includes ways to do things like delete rows. https://domo-support.domo.com/s/article/360043437733?language=en_US