GrantSmith Coach

You need to go to the dataset itself not the ETL

I’d submit feedback to Domo with this. You can find instructions how to do that here https://domohelp.domo.com/hc/en-us/articles/360042922794-Submitting-Domo-Product-Feedback

I'd recommend logging a support ticket and seeing if Domo can investigate the error for you.

You're not able to do this in a beast mode. You can use a GROUP BY tile in Magic ETL and tell it to separate the values by commas as your aggregation method.

There should be a _BATCH_FILENAME_ field in your dataset after the connector runs which will contain the name of the file which was imported into Domo. You could then use an ETL to extract information from your filename that way.

You need to go through the dataset under the history tab you'll see all the prior updates to the dataset. When you hover over a specific version you can select from the wrench menu on the right hand side to revert to a specific version of your dataset. This should allow you to get the data back you lost.

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?