GrantSmith Coach

Hi @Sam1 The API token you authenticate and communicate with us for the user that created the token. So you could have a user which has their permissions limited to read only ( a custom role)

Hi @Jbrorby Apologies for any typos and the lack of screenshots as I’m on mobile If you have Magic ETL 2.0 beta (talk with your CSM to get it enabled) you could try and use the Dynamic Unpivot tile and then after you split your field (importantly here is a select columns tile to drop your original antigen csv list so it…

Hi @MattGo Period over Period charts don’t support percent change. You’d need to calculate it yourself using a beast mode however it’s best to reformat your data using a date dimension table to calculate your metrics on a certain date based on a certain offset (Last Year, last month last week etc. ). @jaeW_at_Onyx has a…

Hi @swagner Looks like you might be able to use their GetFile end point to download a file from the URL however I haven’t use this product so that’s going solely off the documentation you provided. You can start there but you may need to bring in a consultant or someone more technical to complete this connection.

Hi @AlexF Are you talking about ad impressions? You can use the ad Performance API report. Just select API from the drop down then Ad Performance https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_Media_Applications/YouTube_Enterprise_Advanced_Connector

Hi @shannonmoranWF you can use variables within a MySQL data flow following standard MySQL 5.6 syntax

you may also want to look into data assembler if you have a large dataset and could possibly set it up using some partitions but it’s premium feature. There are a few guidelines for using it which are documented in the knowledge base https://knowledge.domo.com/The_Appstore/Available_Apps/Data_Assembler_Usage_Guidelines

Hi @banderson it sounds like you’re talking about an upsert type of connection. There are some connectors which support upsert however it appears that the MongoDB connector isn’t one of them. You could try and do something like a recursive dataflow to handle the upsert logic yourself however note that it doesn’t scale as…

Hi @gbennett Did you mean to say aggregating it doesn’t work? How does it currently work and how are you expecting it to work?

Hi @Kumar619 You can add annotations to some graphs in analyzer if you need to note a specific instance.

Hi @HowDoIDomo I recommend Line + Grouped Bar Chart types of graphs. In the general section you can define the number of metrics or series which make up the line portion of the graph. By default it is just the first value going left to right. You’d need to calculate your differences from last year manually and I’d…

Hi @Grecs5 alternatively you can use a data set view to join your two datasets together. another option to think about might be instead of joining your data together you UNION / stack your data together such that you have TYPE | WEEK | COUNT Demo | 1 | 3 Create | 1 | 10

Hey @swagner I’m on mobile so this is briefer than normal but because you’re attempting to aggregate on two separate levels which Domo doesn’t necessarily like. You might be able to calculate the sub totals or totals using a window function however I’d recommend using a data view on this data set to calculate the data on a…

Hi @jimmy If you talk with your CSM they may be able to spin up an environment with your required packages.

Hi @user082291 has something changed with your date fields? Are there now nulls in your date field? Can you try an alternate method for calculating date difference by using UNIX_TIMESTAMP? ’’’ ROUND(AVG((UNIX_TIMESTAMP(`Investigation End Date`-UNIX_TIMESTAMP(`Investigation Start Date`))/60/60/24),0) ’’’ simply it’s…

Hi @gbuckley you can control which lines are shown after aggregation has applied by clicking on the legend. So you could hide all the other fruits except apples and allow the user to select which fruit they want to display on the chart. Alternatively you could pre aggregate your data in an ETL and calculate your overall…

Hi @user048760 in order for your card to utilize the metric is must be in your dataset. I agree with @Lady_KMac that views are a good option to combine the dataset. Alternatively is it possible for you to add a new card to your page for this metric? That might be a simpler option if you don’t want to combine the dataset…

Hi @serendipity @ST_-Superman-_ is correct. This functionality doesn’t exist currently especially since you’re wanting to conditionally trigger the drill path action based on your data. I’d recommend putting in a feature request for this type of functionality. The only possibility I would see is to utilize PDP to restrict…

Hi @serendipity @ST_-Superman-_ is correct. This functionality doesn’t exist currently especially since you’re wanting to conditionally trigger the drill path action based on your data. I’d recommend putting in a feature request for this type of functionality. The only possibility I would see is to utilize PDP to restrict…

@jaeW_at_Onyx yes. Otherwise it will cause it to be called something like “Unnamed 1” and you won’t know what that column contains. Either give the index a name before you convert it to a data frame or name the Column after

Hi @user09644 Currently you can't schedule execution of a Jupyter notebook. Though notebooks are typically for exploration - can you convert your notebook to a python script and either utilize the Python tile (if you have that premium feature - I'm assuming you do since you have notebooks) within an ETL or a python script…

Hi @user06209 There's two ways of doing this. The first is to create an image card on your dashboard and then change the interaction type to link to something within Domo selecting the page you want to go to. The other is to utilize HTML code in a beast mode to make a hyperlink with an image. The first option is the easier…

@user076872 Beast Modes evaluate on a row by row basis so because your Y and X axis metrics appear to be the same you get the lines. Glad you figured it out!

Hi @user076872 You could utilize a beast mode with the RAND function to add your own jitter for the categorization. For Example: `Rank` + (RAND() * 0.5 - 0.25) You could then use that for your scale instead of just the straight 1-4 values. The downside is that you can't use the categorization of the string values in your…

Hi @stephgalfano You can use a CASE statement to filter some values in your calculation. See CASE WHEN `value_or_expression` <> 0 THEN `value` END Alternatively you could use the filter on your card to filter out other values.

@AJ2020 You're welcome! If you want to change the number of business days this is the template you'd can use. Just change [BUSINESS DAYS] to the number of business days you're wanting to add. DATE(DATE_ADD(`StartDateTime`, INTERVAL (FLOOR([BUSINESS DAYS]/5) * 7 + CASE WHEN MOD([BUSINESS DAYS],5) +…

Hi @AJ2020 MOD is the modulo operation. It simply says "divide these two numbers together and give me the remainder". In other words, how many left over days do I have after calculating the number of full weeks. FLOOR just returns the whole number of a division operation without the fraction. I'm using it in two places.…

Hi @AJ2020 I had a few errors in the prior beast mode one being the extra parenthesis but also missing the final parenthesis on the first case statement. Copy and paste will get you sometimes. Try this: CASE WHEN (`PurposeType`= 'New') AND (HOUR(`StartDateTime`)>=15) THEN DATE(DATE_ADD(`StartDateTime`, INTERVAL…

Hi @user006645 How exactly does your formula not work? What are you expecting and what are you getting? Syntactically your formula looks correct

Hi @user077529 You can utilize a Group By tile in a Magic ETL dataflow to group your rows together and then use the "Combine strings by ," option in the group by tile.