GrantSmith Coach

@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…

Hey @kjones140 I haven't tried this before but you might be able to utilize a recursive dataflow where you have an input dataset of the new data and also the output dataset as the input. You could then perform some auditing as a 3rd dataset on your new data and determine if it's good or not and add a column with value of 1…

Hi @user094816 You can utilize a window function in a beast mode - you need to have this feature enabled in your instance. Talk with your CSM to enable window functions. SUM(SUM(1)) OVER(PARTITION BY `Col1`) This would get you 5 for every ABC123 record. In your example data you have ABC123 listed 4 times and then 1 time…

Hi @user077529 Domo supports window functions (you need to have the feature turned on in your instance. Talk with your CSM if you don't have it enabled) which can get you the prior week's value using the LAG window function. The caveat to this is that it assumes there are no missing week in your dataset. LAG(SUM(`Orders`))…

Hi @Brandon You can schedule a report to send an email with a card at a specific time where you can choose to include the data as an attachment if you're wanting to export data that's been processed / visualized. If you're looking to export raw data you can utilize the Java CLI tool…

Hi @user052846 You've got the basic idea of what needs to happen however the one issue you have is that you're not writing back out a DataFrame object but rather an Index object. If you're wanting to export your index you need to convert it to a data frame using the to_frame() method first before attempting to write it…

what happens if you change the charindex check to be >= SELECT DISTINCT MarketingClubLevel, CASE WHEN CHARINDEX(' ',MarketingClubLevel,1) >= 0 THEN MarketingClubLevel ELSE SUBSTRING(MarketingClubLevel,1,(CHARINDEX(' ',MarketingClubLevel,1))) END AS ClubDescription FROM vClub What does `CHARINDEX(' ', MarketingClubLevel,1)`…

Hi @user063136 You just need to add a partition to your window function to calculate the rank within each specific month. RANK() OVER (PARTITION BY YEAR(`date`), MONTH(`date`) ORDER BY COUNT(`Certificate #) desc)

Hi @jeremymcd You'd need to utilize an ETL to format your data such that you have a record for each hour of the day instead of a record for each status. For example (this is assuming you're only looking at a single day otherwise you'd need to include your date in here as well): HOUR | Status | Agent |Seconds | 12 | Admin…

Hi @AndresChavez What does your beast mode look like you're using to calculate the variance?

What's the query you're running and the error message you're getting? (anonymize it if necessary)

Hi @user092416 Looks like Nielsen is the one who owns and maintains the DMA lists. You might be able to utilize the Zip code list they provide to plot the different regions based on a US map categorized by the region.

Hi @MarkSnodgrass Magic ETL doesn't support a conditional join, only a straight columnar join. The option you can do is perform a Cartesian join and then user a filter tile after the fact. To do that, add a constant of 1 to both of your datasets and then join on that column. The Cartesian join causes the number of records…

Because of leap years and not every year being 365 days I'd recommend using a 1 year or 2 year interval instead. case when date >=currentdate() - interval '1' year then 'this year' when date >= currentdate()- interval '2' year then 'two years ago' ... end

Hi @user009257 If you're wanting to graph when the equipment is being used the current format won't get you want you're looking for. You'd need to instead slice your data to state "at this time I was in use". You can do this using an ETL to modify your data. You'd need to define how granular you want your slices to be but…

Hi @jeremymcd You can utilize some beast modes on the chart to calculate the number of seconds between the timestamps. I typically use the UNIX_TIMESTAMP and basic math to calculate the difference. UNIX_TIMESTAMP(`status_start_at 1`) - UNIX_TIMESTAMP(`status_end_at 1`) You can then group by the `user_name 1` field and the…