GrantSmith Coach

Looks like you don't have enough screen real estate to display the entire modal, can you maximize the browser window or increase your screen resolution?

If you're wanting to add an image as a background to the page you can do that but editing the page, selecting the options menu in the upper right, select change background, change Color fill to Image fill and then select the image you wish to use as your page background.

There isn't a way to force a filter to have a value currently. Typically in this case I'll have a text box on the page with a beast mode that checks to see if the distinct count of records (in your case Region) is more than 1 I'll return a string stating to select only one value as a warning. CASE WHEN COUNT(DISTINCT…

You can utilize the Calendar dataset from the Domo Dimensions calendar to do a conditional join on your HR dataset based on the start date and end date. With Magic ETL 2.0 you can't do a straight conditional join but would need to do a cartesian join then do the filtering after the fact. Depending on your HR dataset size…

Domo doesn’t provide an option to toggle card visibility currently. I’d recommend logging and idea in the idea exchange for this as I’m sure others would find it useful.

Hi @Jack_Kaye Were you able to get the activity log to work for you? If so can you accept my answer so it's easier for others to find? Thanks.

You can search for SQL JOINs to understand the different types of joins. https://mindmajix.com/joins-sql-server has a good infographic outlining how the different join types work that you can apply in your dataflow.

In theory you could utilize a webform or some other dataset with a dataset ID column and another column which would contain the number of days you wish to keep data in your dataset for. You can then utilize a Recursive Magic ETL dataflow to then filter the data down to the values that are within the number you specified…

Hi @Ken Have you thought about stacking your data so you have a record in USD and another record in CAD and then use a filter card (radio button?) to allow the user to select a currency amount which would then filter your dataset to just that specific currency?

I'd recommend formatting your data with a date dimension offset so you can calculate YoY and MoM more easily and have them displayed on your chart. You can then sort those percentages and see which clients require the most attention. I've done a write up of how to do this here:…

Have you looked at the activity log or the activity log DomoStats dataset?

It depends if you're deleting a beast mode that's saved to the dataset or not. If you delete one from the card that isn't saved to the dataset then it's just that card. There isn't a simple way through the UI to get the duplicated beast modes however you can utilize the DomoStats / Data Governance datasets to get the cards…

Have you tried re-authenticating with the connector and re-pulling the data?

Apologies, it should have been the Domo Governance connector and not the DomoStats connector that would have the Cards and Pages dataset.

Are all the fields metrics / numerical fields or are some dimensions / strings? You could try and multiply each value by 1 to force it to become a number: (`Total Bounces` * 1) / (`Total Contacts` * 1)

It lists the card and page on each row in the dataset so you can go card -> page and page -> card you'd just need to filter on the appropriate column.

You can use the DomoStsts connector to get the Cards and pages dataset which will tell you all the cards on a page

Do you have your BeastMode code you could post? (Anonymize the field names if necessary)

@jaeW_at_Onyx - Correct. It will share the dataset with all users of that group. @yli_2596 - You can multi-select datasets in the Data Center and then click the Face with the plus icon in the upper right to share multiple datasets with users or groups.

Those functions are aggregates, are you grouping your data on your other columns? Have you tried just utilizing a MagicETL dataflow after import and using the group by tile and selecting to combine values with commas?

You can do clustering via a Magic ETL tile however it requires you to have the Data Science package add on which is a premium feature. You can read up more on it here: https://domohelp.domo.com/hc/en-us/articles/360045259294-New-Magic-ETL-Tiles-Data-Science#4.

Currently there doesn't appear to be a way to reorder subpages for everyone. There were several posts asking about this in the past but not appears to have come from it. I'd recommend logging a new idea on the Idea Exchance section of the Dojo for this specific request. Here's some older reuqests:…

You could utilize a simple linear trend slope calculation however you wouldn't be able to do it in a beast mode because you'd need to aggregate some aggregations. sum((x−avg(x))*(y−avg(y)) ) / sum((x−avg(x))*(x−avg(x))) This will give you a larger number for faster increasing trend and smaller numbers for slower increasing…

Sounds like Dom is storing it as a non-integer data type (DOUBLE or DECIMAL) so there's not much you can do on the way in. What you could do is run it through an ETL and use the Alter Columns tile to change the datatype to a LONG / Integer to remove the .0 at the end of the values. Alternatively you could set the data type…

It will filter out all rows in the dataset that have an order date that doesn't fall within that week It will only filter based on the date field being used in your selector not all the date field in your dataset

To add a bit more flavor, the M you see is for "Modo Corp" which is a fictitious company Domo uses for their demos.

Do you have a date field being displayed on your card?

You've got a limited space because of the canvas the card is displayed in. You'd need to utilize some JavaScript to allow your menu bar to auto-scroll instead of attempting to display the entire menu. This way it'd have a fixed height but still allow you to scroll through all your options.

Can you just use the Date Selector in your drill path chart to select Last Month?

To fix the sorting create a new beast mode and then have it return as specific numerical value (1-4) and then use that to sort your pie chart. That will reorder the legend in the order you define. To remove the Total under your chart properties - Hover Legend - Title Value set that equal to None