GrantSmith Coach

@Data_Devon It depends on your use case. Having your columns wide will allow you to consume fewer rows overall, potentially reducing your costs. On the other hand, Domo likes things as rows to deal with filtering. If you want to filter your records based on the City, then you'd need to pivot your locations stomore easily…

I'd recommend logging a ticket with Support to have them help diagnose your connector issue as they own that connector.

Have you tried redirecting the user to the same URL but utilizing an empty pfilter get parameter?

If it's not included in the standard connector you could try and leverage the JSON No Code OAuth connector to pull this information.

Have you inspected the network traffic to determine if you're getting an error with your JavaScript code used to save the records?

Sorry getting my languages mixed. You can use NOW() instead of TODAY()

You can use a beast mode calculate if it's a future date: CASE WHEN `StartDate` > TODAY() THEN 1 ELSE 0 END Then just filter for 0 in the beast mode.

In the buildForm function, you'd need to set the input box size conditionally based on the key field.

AppDB should update every 15 minutes. Do you have "syncEnabled" set to true in your manifest? For reference:

Change Type of Values from Number to Text

You can use a window function to do a lag LAG(`Action Time`) OVER (PARTITION BY `Ticket Number` ORDER BY `Action Time`) This can also be calculated using a Rank and Window tile in a Magic ETL Then taking that you can calculate the time difference: SEC_TO_TIME(UNIX_TIMESTAMP(`Action Time`) - UNIX_TIMESTAMP(`Prior Action…

You can use a case statement to convert the 1 to 'Priority': CASE WHEN `field` = 1 THEN 'Priority' ELSE 'Non-Priority' END

When you go in and edit the layout of the dashboard, are you able to see the delete / trash icon when hovering over that section?

You can use a Select Column tile to set the ordering of your columns in your output dataset.

You can feed it into a regular expression in a formula tile to convert () to a negative number with something like this: REGEXP_REPLACE(`field`, '\(\d+\)', '-$1')

You need to remove all non-numerical characters first. In a formula tile you can do something like this: REGEXP_REPLACE(`field`, '[^0-9.]', '') Then feed that into the Alter Columns tile

This is because how your Beast Mode is written, it aggregates everything first and then just subtracts an hour. What you'll want is (assuming you're filtering for records where the duration is already > 1 hour: SEC_TO_TIME(SUM(`End Time` - `Start Time` - 3600))

Filters work on a per column basis so you couldn't have an individual filter for all of the dates. What you may be able to do is utilize a Date Dropdown variable, write a beast mode to determine if any of the dates are between the start date variable and the end date variable and return 1 if they are or 0 if they are not…

You can use a beast mode to define a custom sort value to use in the sorting section of your chart CASE WHEN `field` = 'Ro' THEN 1 WHEN `field` = 'Ac' THEN 2 WHEN `field` = 'Tr' THEN 3 END

You'll need to make sure your app is sending out the filter request to the container. You can use the domo.filterContainer() method outlined here:

The last time I utilized the backup and import backup, it created new jobs with the same definition but with new datasets and job IDs, which caused a lot of issues and duplicated datasets. What I recommend doing is doing a registry migration where it treats the new server as the existing server and Domo will restore all…

Have you reached out to your Domo Account Team to have them help you get this embedded into your embeds? They'd need to do it as they control the embed code. The process is outlined here: Follow these steps to enable FullStory tracking for your embedded content. Contact your Domo account team and request to enable embedded…

Have you tried using the TBA connector with a custom saved search?

when would the order be defined? Based on the 2019 data point or 2024?

On your top condition you are returning `Total referrals `=0. If you want it to be 0 in this condition then just return 0 case when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= '10/23/2024' then 0 ELSE `Total referrals` end

You should be able to just use the REPLACE function like you mentioned: REPLACE(`Client Name`, '"', '.') How is your beast mode not working? What are you getting and what are you expecting?

It's definitely shared with your user. Next steps to confirm I'd recommend going to https://developer.domo.com/manage-clients and logging out if you're already logged in, then log back in making sure you're using your user when you're logging in. You can then confirm the client ID and Secret that you're using with your…

Try putting your aggregation outside of your case statement SUM(CASE WHEN `Age group` IN ('121-180 Days','181-270 Days','271-365 Days','366-730 Days','731 Days+') THEN `CurrentBalance` END)

Essentially, the error tells you that the user who created the API Client (client ID and secret) doesn't have access to some of the cards on the page you're embedding. I'd try to unshare and reshare the page with the user and confirm that the embed ID is correct. The scopes on the client just tells the API which API…

Beastmodes don't have access to the selected date grain on the date selector so you won't be able to do it that way. You could utilize a variable to select the date grain which you would have access to.