GrantSmith Coach

@JasonAltenburg It's a Trellis Chart. You can read more on those here: https://domohelp.domo.com/hc/en-us/articles/360043428713-Applying-DataSet-Columns-to-Your-Chart#6.

Can you just use additional segments in your group by to include the month and collection type?

Does the former owner still work there or do you just need to change ownership? If you want to change ownership of the user's cards to yourself you can use the Java CLI and the swap-owner command and have it swap just the cards owned by the original owner to yourself.

I've written up a very simplistic example of adding business days which doesn't take into account holidays or when the business may be closed. @Gordon_Pont is a more correct solution to account for these holidays and weekends but wanted to share how you can roughly do it with a formula:…

Hi @bradw Due to how filters function within Domo you can't have a single filter column and multiple values applying to different cards. You could copy the date value into a different column and then have the other cards use the new column instead of the first column so they're separate values to filter on. Because you're…

Typically I'll do the same, pull in the raw tables with the actual field names then consolidate the business logic and renaming of the columns to be a standard value in the ETL (Magic or View) this way the same name is used across all cards and I have my actual raw tables with no modifications for easier debugging.

You could utilize the Domo Data Governance Connector and pull in the Card Fields and Beast Modes dataset which will list all the fields used on a card and has identifiers if the field is a beast mode or not.

Are you wanting to manually set this column or should it be getting pulled from your pendo connection?

Hi @akeating I'd recommend you reformat your data in a friendlier way to allow you to more easily calculate Period over Period difference. I've done several write ups on this in the past with step by step instructions on how to accomplish this:…

@domoSteve Since Domo doesn't have a connector you'll likely need to implement your own custom connector for the ActiveCampaign APIs (https://developers.activecampaign.com/reference/authentication)

Have you inspected the network traffic to see if it's returning an error for you when attempting to call that API endpoint? Does your data schema match the existing schema? Have you tried passing in your CSV data as the second parameter to your domo.put call? var q = `data/v1/${datasets[1]}`; domo.put(q, csvData);

Domo doesn't support OR filtering with quick filters. You could attempt to use a beast mode with the OR logic and then have a quick filter on that beast mode instead however it's not very scalable.

Could you filter for only the D0330 procedure code in your main card and then have your drill path filter out the D0330 procedure code and have the user click on the appointment number to filter that specific appointment in the drill path?

Instead of using count for your orders you need to sum them instead.

You can't use commas in numerical comparisons. Also as @MarkSnodgrass mentioned you're missing a THEN in the last WHEN clause.

Those are great suggestions that you can add to the Ideas Exchange. HTML editing gives you much more flexibility with the layout of the message you're attempting to send. If you're not a front end developer I'd recommend looking into WYSIWYG HTML editors which will allow you to more easily design HTML code with drag and…

The connectors write to only a single dataset based on how they've been architected. You'd need to set up one connector for each individual report. Alternatively you import all of them into a single dataset and then filter for the report you need out of that dataset. You could also apply PDP to the dataset to restrict…

This sounds like a bug, I'd log a ticket with Domo Support to see if they can get it addressed.

Are you utilizing a DataSet View or Data Fusion as part of your dataflow? Those run on the Adrenaline layer and if they can't run or have too much data to process sometimes you'll get the error you're seeing.

Domo Workbench is attempting to process everything in an American way. To get around the date issue you can utilize a Custom Date Format Transform on your data where you can specify the specific date format for Domo to interpret your data.…

No, there isn't much documentation around the export-data command on the knowledge base. You can get help on the command to tell you what parameters it expects when running the command: > help export-data export-data: Exports DataSet to a CSV file export-data -i <dataset_id> -f <file_name> usage: -f,--filename <FILE>…

You can't send a text directly from Workbench however there may be a few different workarounds. Major carriers in the US may offer the ability to email a specific email address to then send a text message. This article may be helpful: https://www.techwalla.com/articles/how-to-convert-email-to-a-phone-text-message…

You can utilize MagicETL and a JOIN tile with a left join. The left dataset should be your master schedule and your right table should be the Secondary schedule. Then you can use a filter tile to filter for blank values in the secondary schedule's URN value. This will show all records in the Master Schedule which aren't in…

You can do something like this to handle NULL / empty values: CASE WHEN `Planning Condition Status` IS NULL THEN 'Blank' ELSE 'Not Blank' END

Hi @Steve-DOMOnoob currently the only supported method is to do a recursive dataflow. You can read up on how to do them here: https://domohelp.domo.com/hc/en-us/articles/360057087393-Creating-a-Recursive-Snapshot-DataFlow-in-the-New-Magic-ETL You can also talk with your CSM if there are any other options for you to opt into

@chrishaleua may be able to speak more to this but I believe it's left in there to know that it was embedded at some point and for reference of old embedded links. If it's turned off you lose the record that if there are questions on the embed link in the future.

This is the embed server that handles embedding. It's a bit confusing with the domain being public but all the logic is handled there for private and public embedding. @ChrisBaker@chrishaleua may be able to shed some more light on this.

Since you're doing a windowing function have you looked into the Rank & Window tile?

Hi @Sara321 You can't aggregate an aggregate. You'd need to use a dataflow to pre-aggregate your data to calculate your max month. The downside to this is that it's not affected by any filtering taking place on your card.

This is the intended functionality with workbench when you import jobs from a JSON definition. It creates a new job definition (I'd disagree that this should be the default behavior and should instead ask if you want a new job created). If you're migrating a server you can do some registry hacking to make it think the new…