GrantSmith Coach

Hi @SumanK I don't believe there's a way to customize the message sent in the scheduled report however you may want to talk with your CSM to determine if the Campaigns App add-on would be able to solve your problems (you can search for it in the Domo AppStore to see how it works as well) You may be able to add a text card…

Hi @user16346 Is it possible for your GA instance to contain transaction IDs which start with a character or should it be assumed that it's always going to be a number?

Hi @user032625 , Because of the flexibility of Domo it is difficult to direct you on how to solve your general question. It would be helpful if you had some sample (and anonymized) data to review and help direct you with the best solution. If your data is formatted as a single row containing the date when the content was…

Hi @user06643 If you set the rows to be collapsed in the Analyzer and then save save your card it will default to the rows being collapsed for users when they load the card.

Hi @user031517 A little more information about how your data is structured would help or some sample anonymized data would be great too. Without knowing how your data is structures it's difficult to pinpoint the problem. How is the data being populated? Is it being done via a join? What does a single row in your dataset…

Hi @tstimple , You can utilize the windowing function LAG to calculate the rolling average based on the number of days. Window functions are a feature switch so if you currently don't have access to them talk with your CSM about getting it turned on. Example 5 day rolling window: (LAG(COUNT(`one column`), 1) OVER (ORDER BY…

Hi @HashBrowns Unfortunately right now that's not possible to conditionally set the label text color. The code snippet you have only works on table cards which allow HTML markup. Bar Charts currently don't support it. I've been looking for this functionality for a while as well but they don't have it yet.

Hi @PhilD , Are the only two fields you have listed the location and your count distinct calculated field? If that's the case then your locations might appear the same but aren't actually the same (perhaps a trailing space). Can you try wrapping your location in a new beast mode to strip any trailing spaces?…

Hi @user021892 - Welcome to the Dojo! Your data sources and your use case will determine how you want to combine your datasets together. Lets say for simplicity sake you have two different datasets with the following data: Sales: DateSaleQuantity1/1/202050001002/1/202075001503/1/2020250050 Revenue:…

@Sandis You can use a Fusion to union the two tables together which would likely be more efficient than an ETL but it's up to you.

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.