GrantSmith Coach

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.

@user028768 Correct. You can change the data in Magic ETL however you won't be able to make much use of it within a Card in domo because it won't interpret the formatting and just treat it as text.

Hi @user028768 You can use the replace text tile with a regex. You can perform a regex on multiple different columns in the same tile but you'd need a tile for each formatting. The other thing to note is that the text cards typically don't support any text formatting with the exception of the HTML table using HTML code.

Hey @Stephane I'm glad it worked for you. Can you make sure to accept my answer so others can easily find the solution if they have a similar issue?

Hi @DataSquirrel If you're using Workbench 5 there is the ability to define an UPSERT key to replace existing records based on the defined key. It's outlined in the knowledgebase here: https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Using_Upsert_in_Workbench_5

Hi @akshayaviswanathan Have you looked into Beast Mode Manager (https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Beast_Mode_Manager) to allow you to change your beast modes across multiple cards? Is your beast mode you're wanting to change saved to the card or to the…

Hi @psmith Regular expressions are one way to solve your problem. Assuming your text is ONLY HH:M:SS OR MM:SS you can utilize a replace text tile (Magic ETL 1.0 or 2.0) to pad your MM:SS formatted strings to be 00:MM:SS Here's the regular expression you can copy and past: ^(\d{2}):(\d{2})$ And here's the Replacement…

Hi @AJ2020 This was a fun question that I had to play around with. Currently you can't just say "add X business days" to the date_add function (though it'd be great). The following beast mode will add X number of business days to a date however it's not smart enough to exclude holidays. Here's the basic version of it…

It depends if the index has a name or not. When you convert the Index to a dataframe the Index Name becomes the column name. I'm not certain how Domo would handle having an empty column name, likely it wouldn't like it so you might want to set the name on the index first if it isn't already set before converting it to a…

@jaeW_at_Onyx I suppose yes, you could utilize something like a Python script (utilizing the pydomo package) to export the data, do some validation and then kick off the data flow if they pass as an orchestrator. You could set the DataFlow to be triggered by the execution of the dataset that would need to be validated so…

Hi @lwang Currently there isn't an a supported method (connector or api) to get alert history as a dataset. You might be able to work with your CSM / Domo to see if they could inject that information into your instance as a dataset.

Hi @AJ2020 Flex tables can only support a bar chart or a line chart for the visualization. If you must use a gauge and can't use a flex table then you'd need to create a dashboard with all of the different visualizations / cards you'd need.

Hi @user066906 Typically when I have a complex beastmode that isn't functioning as expected I'll break it down into different beast modes and toss them onto a table card to help investigate each portion. Does your payment check return what you're expecting on it's own without the SUM for each record? CASE WHEN `Payment…

Domo spins up a local environment / container for you to execute python code in. The only thing that Domo really controls is the read_dataframe and write_dataframe. If you take out the Domo aspect you can think of read_dataframe and write_dataframe similar to read_csv/write_csv or read_sql/write_sql. The only difference is…

Very interesting @pydomoguy . Have you thought about utilizing the pydomo package to just straight import them into Domo instead of having to then go through Workbench?

What you'd need to do is have a dimension table of all times within a given day on a minute by minute basis. You can then utilize a DataSet View (instantly updates when underlying data updates. Might still be in beta. Talk with your CSM) to left join your data to this time dimension table. Then you can graph by the time…