GrantSmith Coach

Are you doing a platform embed? There should be a profile icon in the upper right for you to log out of. I know you can access the logout link directly: https://{customer}.domo.com/auth/signout

I'd recommend calcluating the first date of the week and use that for your sorting. If you have a Date field you can do something like this: `Date` - INTERVAL (DAYOFWEEK(`Date`)-1) DAY This will return the Sunday of the week.

You can configure cards on dashboards to link to other objects within Domo so you can have them link to another dashboard. If you're wanting to go to a specific section (like an HTML anchor tag) this isn't currently supported. Some cards do support HTML coding directly within them (table cards) such that you can have the…

There isn’t a simple way to ungzip the data coming back within the connector ide and domo doesn’t allow for external packages for security reasons. You’d likely need to write your own gzip function based off an existing gzip package

If you have one value per month you can utilize a LAG window function. I've written up about these here: Alternatively you can restructure your data so that you have a period type (Current, Last Month) and a specific value for your months then utilize some beast modes to calculate the difference. Here's another write up on…

There isn't an official way of doing this however you could attempt to monitor the network traffic for the API calls Domo is making and replicate those within a script.

Alternatively, you can use smart text either in the title or description of a card or use a text card with smart text to show when a dataset was last updated.

You should be able to ignore the fields parameter in your query and it should return all of the fields that are in your dataset.

You can use a filter tile with a formula and the CURRENT_DATE() function: `Date` < CURRENT_DATE() - 1

To clarify, the issue is that you're having is that your beast mode is always returning NULL now as the MONTH function returns a number 1-12 based on the month. MONTHNAME returns the name of the month. Instead of using a case statement to attempt to compare the value to the month names just use MONTH(`Offer Accepted`)

This is likely because you're sorting based on the Year first and also the month by name. You'll want to sort by the numerical version of the month first and then the year. You can use the MONTH function to get the month number. Alternatively you can use the LAST_DAY to get the last day of a month and sort on that instead…

You can't aggregate an aggregate in a beast mode unless you're attempting to use a window or fixed function. Also, you can't compare an individual value to the aggregate of that same value within the same beast mode. Again this can be resolved with a window or fixed function: COUNT(DISTINCT CASE WHEN `Start` >=…

Can you post some examples of your raw data before your replace text and also what your replace text tile settings look like? There may be a more programatic way of solving your problem with a regular expression.

You used to be able to do this with the CLI tool and specifically the backup command; however, it's since been deprecated per the documentation but you may be able to still utilize this > help backup backup: Performs a backup operation, to AWS S3, for all Domo entities of type <t>. backup -k <S3 Key> -s <S3 Secret> -b <S3…

Domo doesn't provide a way to set a default for a filter card on a page except for using the page filters. You may be able to set a default page filter as @MichelleH mentioned which should affect the embedded dashboard.

You could use the start date of the week as your date range so that you have a single week value like your week number but is an actual date. You can use a formula tile and a formula like: `date` - INTERVAL (DAYOFWEEK(`date`)+1) DAY Then you can group your data on this date to either take the min, max, sum or whatever…

@fromMinnesota It looks like you may need to use square brackets instead of parenthesis with your in statement: It expects an array, which is denoted by square brackets. It's not the same as the SQL version of IN used with beast modes or formula tiles.

When you add a null to a number the result is null. Wrap your SUMs with a COALESCE to return a 0 instead. COALESCE(SUM(ActionsPost),0)+COALESCE(SUM(ActionsPostReaction),0)+COALESCE(SUM(ActionsComment),0)

Can you expand on why you're wanting something similar to IFNULL in your first condition? Do you want to include the AMT if either flag is set to Y? Can you give an example record which would fall into the scenario you're talking about?

Are you doing this inside a formula tile or a beast mode? If it’s a formula tile in ETL you can’t use aggregations (SUM) as it doesn’t know how to group them. You can do it using a group by tile in magic instead and have a custom aggregation alternatively you can remove the sum in your formula and then just sum your new…

The error message can't be supressed but you can increase the row count on the card to a much higher number. By default cards will load 25k or 50k but increasing it will allow more records to be loaded. The caveat to this though is that the more rows you request the more RAM / Memory it will consume on the user's machine…

Under General you can set a No Data message to display if no records are found

On your input dataset you can go to the configuration tab, find your field and then change it to Date data type. If you click the gear next to the field you'll then see a Date settings submenu. Go into that and you can set your date format there: %Y-%m

Feed the dataset into a magic ETL. Depending if you care about the possible duplicated records or not you can either set the output method on your output dataset as Append to just continually add the rows that were imported. Alternatively if you're using dates or some sort of partition that you'll be overwriting ever time…

Regexp replace in a formula tile should work for you. Autoformatting is messing up the expression so here's a screenshot: REGEXP_REPLACE(`field`, 'REGEX HERE', '$1')

The Domo API is authenticated as the user who creates the dataset. So if you created the Client ID and Secret, then it's emulating your user with your permissions. You'd need to create separate Client IDs and Secrets for other users with restricted access to certain datasets to allow them to only see what they would have…

You need to use the backticks (`) instead of the apostrophes ('). Backticks represent a column name; apostrophes are for literal string values, so when it's 'Column A', you're getting the actual string Column A instead of the value inside the field.

Because you have empty strings it doesn't know how to interpret it as a number. You can try and use a formula tile to convert it to null which should then allow you to convert it. NULLIF(TRIM(`Column A`), '')

This is likely because you have the data as multiple rows instead of on a per-brand record. You can use a magic ETL with a Group By tile and then aggregate (with a sum aggregation) your revenue and quantities together so that each brand has one record with all your data together to condense the duplicated rows.

I'd recommend reaching out directly to the training team about this.