GrantSmith Coach

Is the API you're connecting to able to return only the changed records? If that's the case then you'll have to use a recursive dataflow as there isn't an upsert option for the connector. If your API returns all your data then there it's much you can do.

@Garrett_Kohler It appears to be a bug. I'm seeing the same thing in my case as well. I'd log a ticket with Domo Support.

Yes it came out with the Domopalooza 22 release. Here’s more information on the latest release https://domohelp.domo.com/hc/en-us/articles/360042936114-Current-Release-Notes#1.10.

There doesn’t appear to be any documentation on the values. It’s be nice if it came with column definitions in the schema but it doesn’t and those are the programmatic values that are being returned. You could try and reach out to your CSM to see if they can get an answer from development for you.

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?