GrantSmith Coach

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. 

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.