GrantSmith Coach

Hi @Sandis How are you pulling in your data? Are you pulling in the most recent records only or are you pulling in your entire dataset? You may want to look into utilizing UPSERT in Workbench 5 - https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Using_Upsert_in_Workbench_5 to only insert the records…

Hi @user007486 You're correct. The Join tile in Magic ETL only supports direct equality and doesn't handle BETWEEN type joins. What you could do is do your ID join and then utilize a filter tile to restrict the records after the join but might be a bit inefficient since it's reading all of those records and then doing a…

Hi @usergru How I've typically done this in the past is to have two separate datasets, live and historical. For the historical dataset I'd have it APPEND the data from 8 days ago every day. For the live dataset it would REPLACE the dataset with the data from the past 7 days. Then you can utilize a data fusion to stack /…

Hi @user11651 I haven't used the Salesforce connector but it's a data type issue. You might need to check to see if you can force the column type within the connector itself. If not you could modify it within your Magic ETL by using a Set Column Type to convert it to a string and then use String Operations to left pad your…

Hi @user084060 This is likely because of your numerator CASE statement where it only returns a value if sales=true. If you have a record where that condition isn't met NULL is returned and anytime NULL is divided by another number NULL is returned. Without seeing your data I'd recommend something like: select…

Hi @user022825 You can utilize the BINARY keyword to force MySql dataflow to do a case sensitive join. selecttable_1.*,table_2.*from table_1left join table_2 on BINARY table_1.manager_id = table_2.manager_id_2

Hi @hamza_123 I believe Domo has the ability you to utilize the NULLIF() function where it will return if a field meets a specific column. COALESCE(NULLIF(column_x, ''), NULLIF(column_y, ''), NULLIF(column_z, '')) If not you could wrap it in CASE statements. CASE WHEN `column_x` <> '' THEN `column_x`WHEN `column_y` <> ''…

Hi @user015090 If you're wanting the GA property to be open to other course builder apps I'd recommend using the instance URL. If you only want that property to be associated with that specific course builder app then use the app URL. I believe @Ashleigh has done something similar with Course Builder and Google Analytics.…

Hi @matthewstryker SQL doesn't handle reading different/variable column names in an SQL statement very well. What I would suggest is instead of storing the values in a wide format (columns as values) I'd recommend storing them as a narrow (also known as Tidy) format so you have two columns: Metric/Name and Value. Your…

Hi @gotex The blue text is because you make the text a hyperlink (<a href=...>). If you don't need it to be a hyperlink remove the anchor (<a> & </a>) tags from your text. If you need to have the hyperlink you'll need to add a style to the <a> tag: <a href="#" style="color: #bbe491"> Also make sure you're using an HTML…

Hi @shamal Admins are a pre-configured role and have access to everything within Domo. If you're wanting to restrict users to not be able to see everything you'd need to create some custom roles and assign the users that specific role which would allow you to filter the PDP. One downside is that they'd lose access to…

Hi @user036002 , You'll want to look at either the Domo Governance Third Party datasets. They contain information about the different objects within Domo along with meta data. Specifically the Data Set Details dataset to see card count = 0. You'll also need to do some ETL magic to join the datasets to dataflows to see that…

Hi @user030238 Currently this isn't an option and each card would need to be updated individually.

Hi @Joe_M 1) If you have the card filtered to a relative time (i.e. Last Month) and not the specific dates themselves then it should be filtered only the last month and update each month automatically. 2) Correct, those are for scheduling only.

"Retail"MAX(CASEwhen `Loan_Originator_Type` = 'Retail' THEN 'Yes'else 0end) "Wholesale"MAX(CASEwhen `Loan_Originator_Type` = 'Wholesale' THEN 'Yes'else 0end)

Hi @user063136 A quick hack would be to aggregate these columns in Analyzer with a max() function which would cause Yes to override your 0 value. This is assuming the rest of the data you're displaying isn't unique or it's aggregated.

Hi @gbennett You're need to make sure you're selecting an SQL Table transform and select the columns you want from your table along with that code. SELECT `col1`, `col2`, DATE(`order_date`) - INTERVAL (DAYOFMONTH(`order_date`)) DAY + INTERVAL 1 DAYfrom `my_table`

Hi @gbennett If you have the ETL 2.0 beta you can utilize a formula tile and write a formula like (It'd be the same if you want to do it as a beast mode): DATE(`Date`) - INTERVAL (DAYOFMONTH(`Date`)) DAY + INTERVAL 1 DAY Essentially you're subtracting the day of the month from your date and adding 1 day to get the first of…

Hi @gotex You can do this with a beast mode and some HTML magic. You'd need to have the URL as part of your dataset (or could conditionally set it in a beast mode but that's not as clean and harder to maintain). CONCAT('<IMG src="', `URL`, '">') What beast mode were you using? What issues did you run into? 

Hi @user063136 Domo has some really good developer documentation outlining creating a custom connector. I suggest you review https://developer.domo.com/docs/custom-connectors/connector-dev-studio for additional information. 

Hi @MosesWynn Did you mean to have the trailing space in 'NPAC-CCS '? Doing a TRIM on your column and comparing it to the value with a trailing space will never match up.

Hi @MosesWynn Are all of your NPAC-CCS records still appearing or are some records being filtered / identified correctly (Essentially - are you getting into the first section of your beast mode)? Is it possible there's whitespace around the `Last Leg Product` field (did you try and wrap it in a TRIM function)? Have you…

Hi @JonavilCello There isn't an exposed public API that will easily do this for you. You could utilize the existing APIs for cards, datasets etc to get a list, filter for your old user and then issue update API calls for each of those objects using the appropriate API endpoints.

Hi @user063136 Looking at the Domo connector it appears like you'd need to connect each individual GTM account in Domo to pull in the data associated with each account. You'd need different account connections. Once you have all of those dataset configured you can utilize a Data Fusion to combine them all into a single…

Hi @user025702 It seems like a bug you might want to bring up with support where the data labels are being ignored when displaying the hover text.

Hi @Yogesh You might be able to utilize the Java CLI tool to download the dataset definition, export the dataset as JSON, manually change the JSON to add the additional fields and then re-upload the dataset using the CLI. Make sure you make a copy of your dataset first and use that for testing before you attempt to do this…

Hi @nj-John-mirc I've created some inventory pages utilizing the Data Governance datasets. Specifically I have a list of all of the dataset within our instance, show their name, description and the owner and direct users to contact the owner if they need access to that dataset. I've also configured a drill path to show all…

Hi @user045611 , An exclusion option isn't an option with PDP. Likely this is because of security reasons because it's better to not give access to all the data and have someone request more access rather than assuming they should have access when a new value gets added and they see data elements they shouldn't have access…

Hi @user08779 I haven't see that issue occur in my instance - have you tried reaching out to support?

Hi @MichelleH Have you tried closing out the app and restarting it or rebooting the phone? I might be a caching issue.