GrantSmith Coach

How is your total not summing properly? Is it too high? Too low?

Each row can't be from last month and 2 months ago at the same time. You could possible aggregate on each product code and sum the 2 months ago and last month ago to get the totals.

@ozarkram you have an extra closing parentheses at the ends of sum(`LY SALES`). There should only be one

NULL represents a missing value. You could try something like this to handle an entire string and null values NULLIF return NULL if the column has the value specified - empty string in this case - and COALESCE returns the first Non NULL value in the parameters supplied. In other words return the company name if it’s…

Hi @ozarkram you can use an HTML table and some conditional coding in a beast mode to accomplish this. I have a talk at DP22 about this topic and did a write up here: https://dojo.domo.com/discussion/54554/dp22-using-beast-mode-to-build-data-storytelling-formatting-text

@mberkeley If you could accept my answer to your question so others can find it easier in the future I'd appreciate it. Thanks.

@Joe_M How was your scheduled report created? Was it being viewed in a monthly aggregation when it was created or a daily aggregation?

@ozarkram If you could accept those answers to your question so it's easier for others in the future to find I'd appreciate it. Thanks!

Hi @ozarkram It sounds like you're wanting to restrict which data is visible depending on specific user criteria. This is what PDP was designed to do. You can enable PDP and define the criteria for the records users or groups are allowed to see. You can read up on PDPs here:…

@svetlana You're welcome. If you could accept the answer so it's easier for others to find who may have this same question in the future I'd appreciate it.

You can’t dynamically disable drill paths but you could utilize a different dataset on your drill path card which had PDP enabled to only the groups you wish to have access.

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.