GrantSmith Coach

You can try and use a beast mode with a fixed function and filter on that beast mode: CASE WHEN `dt` = MAX(MAX(`dt`)) FIXED () THEN 'Latest' ELSE 'Not' END This example uses a dt date field but you can then put this into the filter and filter for "Latest"

You can calculate the beginning day of the week using a beast mode: `date` - INTERVAL (DAYOFWEEK(`date`)-1) DAY Alternatively though I recommend using a date dimension table with custom offsets to make this easier so you can see how many you have from the prior week and calculate week over week differences. I've written on…

@TC1199A Have you tried looking into doing a dataset alert on your dataset where you're calculating the days? https://domo-support.domo.com/s/article/360042925994?language=en_US

Are you experiencing a syntax error or a logical error where you're not getting the results you're expecting?

In the properties under Hover Legend you can check the box to hide the legend to remove the totals on the right hand side. Unhidden: Hidden:

It's attempting to connect to Clarizen. Have you confirmed your Clarizen username and password are correct and you can log in with them?

Domo is having an Innovation Summit about its AI offerings at the end of this month on the 29th or 31st. It may be beneficial to attend to see what they offer: https://ai.domo.com/innovation-summit

Currently, history isn't provided for connector setting changes. I'd recommend adding this to the ideas exchange as a lot of users would find this helpful.

You can use a formula tile and the REGEXP_REPLACE function to get just the value of your match. There isn't a regex substring function so you essentially have to match the entire string and then replace it with your value: REGEXP_REPLACE(`field`, '^(?:[^_]+).*$', '$1')

Beast Modes have no sense of the global date filter on the page so you can't set it to whatever is currently filtered. You may be able to leverage a custom Domo Brick and some javascript to attempt to get the filter options when the filter occurs with the onFilterUpdate event handler. More information on this can be found…

For the first part, you can use a beast mode to select the greater of CURRENT_DATE and your task date and use that as your date. You can update the logic in your beast mode to also check to see if the end date is < the CURRENT_DATE and if it is then just use the start date and end date normally. CASE WHEN `end_date` <=…

Have you looked into the advanced scheduling options? There are several there which may fit your use case: https://domo-support.domo.com/s/article/000005216?language=en_US Specifically: DataSets have updated — This condition lets you activate the trigger when one or multiple DataSets have updated. If you choose this…

There's a KB article that outlines viewing the lineage in analyzer view but also has a video on there on how to view the lineage on a card. This video may be beneficial: https://www.youtube.com/watch?v=kkvNS4BCB1w

Since you want to ignore if an entire row is all 0s there isn't a simple built-in way to do this. You could write a beast mode which would aggregate all of the different values together for each row and then filter them out as @colemenwilson mentioned above.

Have you tried including the URL in the message and seeing if Slack will automatically create a link out of it? You'd likely need to edit your alert message with the URL you want them to go do.

You need to do something with the promise which in simple terms is just waiting for the data to return. You can do something like this to do something with the data when your query is finished running domo.get('/data/v2/dataset?limit=100') .then(function(data){ doSomethingWithTheData(data); console.log("data", data); })

There's several different JSON connectors you can use to connect to the API depending on your authentication method (assuming your endpoint uses JSON). These KB articles may be helpful for your use case. Basic JSON https://domo-support.domo.com/s/article/360043433253?language=en_US JSON Connector with Custom…

You can do this with a window function: MAX(FIRST_VALUE(`value_field`) OVER (PARTITION BY YEAR(`dt`), QUARTER(`dt`) ORDER BY `dt` DESC) This will get you a single value of the first value for each year+quarter partition. Since it's ordering by the dt field it'll get you the last date in the quarter.

The DAP ID has been around since before partitioning. I've never been able to fully establish what it represents. My guess has always been some internal Domo ID. It'd be great if the metadata datasets came with helpful descriptions of each of the columns.

I'd recommend reaching out to Domo Support so they can look into this bug in their plugin for you.

You can do this in either a Beast Mode in a card or a Formula Tile in a Magic ETL. `Column` * 3.1415926535 What does you example beast mode look like?

You can combine the metrics together in the same dataset and use the Site as your series so it'd look something like this: Here's what the sample dataset looks like: One thing to look out for would you may need to enforce the sorting so that the CTR comes before the other sites so that it'll show up as the line. You can…

You'll likely need to create your own custom app to handle the authentication. You can read more on how to do this here: https://developer.domo.com/portal/5d8f965eb3469-overview

Hi @louiswatson You can do a left join from your existing dataset to your dataset 3 based on the Database Number. If the right table's Database Number is NULL then it doesn't exist in the left table. You can do a left join (or right join) and then filter on a NULL value.

You can utilize a Trellis Chart options in the bar chart. https://domo-support.domo.com/s/article/360043428713?language=en_US - This give more information on how to configure it.

You can use a formula tile and the regexp_replace function: REGEXP_REPLACE(`field`, '[\n\r]', '') [\n\r] - This is a selection of either types of newline characters (\n for mac/unix and \r\n for windows)

Are you able to do any other API calls with that client id and secret? A rate limit would return a 429 error code - Too Many Requests. This is pointing to a permissions issue.

Does your token / client id & scecret still exist or have they been revoked? Does the user that the token / client id & secret was created for have access to this specific dataset?

What does your function look like? You should be able to do something like this: STR_TO_DATE(`str_field`, '%b-%y')

Congratulations @colemenwilson!