GrantSmith Coach

This appears to be an issue with the Domo connection. You'll need to log a ticket with Domo Support to have them investigate this issue.

You can do a conditional beast mode to calculate your revenue or cost calculations and not use the type as a grouping Revenue CASE WHEN `Description` = 'Revenue' THEN `Actuals` ELSE 0 END Cost CASE WHEN `Description` <> 'Revenue' THEN `Actuals` ELSE 0 END Profit CASE WHEN `Description` = 'Revenue' THEN `Actuals` ELSE 0 END…

Hey @jakebutterfield I recommend restructuring your data model so you can have multiple periods for each date (in your case this year and last year). I've done a write up on this in the past which might be helpful for you.…

If the beast mode is saved to the dataset on all of the subsets with the same name then it should work.

There are some limitations to the columns and rows for a table card. This article helps outline some of those limitations and the limitations of Excel if you're attempting to export the data https://domo-support.domo.com/s/article/360043429573?language=en_US#row_limits Also, visualizations have a default row limit of 25k…

@james_kibugu - Domo is expecting the dictionary keys to be non-empty due to how it processes the data however normal python is ok with having non-empty strings. I'd recommend adding a check in your code to look for empty strings and then set it to a specific value or ignore those records in your dataset.

You can utilize the Domo Brick called "D3 Ranked Animated Bars Brick" as a starting framework to help you update the graph over time. You'll just need to change the type of graph being displayed from a bar chart to a choropleth map instead. You can find it in the App Store.

Are you attempting to delete the all rows policy? What is the filter logic for your PDP you’re removing?

Domo provides an example in their Python SDK you can reference: https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py It does need to be created by the API.

Alternatively you can simplify this with something like the following: case when DATE(`Alarm Received Store Time` - INTERVAL 6 HOUR) = CURRENT_DATE() - 1 then 'Include' else 'Exclude' end

Hi @Aag2023 It sounds like you need a recursive data flow. There is a great KB article on it here: https://domo-support.domo.com/s/article/360057087393?language=en_US

Currently no, annotations are not compatible with table cards. I'd recommend adding this to the idea exchange for others to vote on this option. It'd be great to be able to annotate a specific cell.

@kav_100 Without seeing your SQL code, CURRENT_DATE doesn't exist in MS SQL. You can use GETDATE in it's place. Alternatively use CURRENT_TIMESTAMP

@donna_torrice - Domo stores your job definitions externally so if you're reinstalling Workbench they should re-appear after installation assuming the server information remains the same. If you're still worried about losing your jobs you can export your jobs in workbench before you do an upgrade however if you attempt to…

Assuming you're wanting the numerical value out of the hidTxtGonSearch field you can utilize a regular expression in a formula tile in Magic ETL. REGEXP_REPLACE(`field`, '^.*hidTxtGonSearch=(\d+).*$', '$1')

Are you using a Magic ETL transformation with a formula tile or a MySQL transformation? Is your PRODUCT_KEY field a date field or a text field or a numerical field? Why are you casting it to a string, then to a date, then to a string and finally back to a date again? Assuming you're using a formula tile in Magic ETL: If…

You may need to pre-aggregate your dataset in an ETL as there's too much data for the chart to display.

Have you looked into a Grouped and Stacked Bar Chart? That seems like what you're wanting: https://domo-support.domo.com/s/article/360042924574?language=en_US

@Ajita it would help to have more information. What is the error you’re experiencing? What are you seeing versus what are you expecting? I’m not sure if it’s a copy and paste error but you might be missing a space and a.Year

Auto selecting a value on a filter card and giving it automatically update the page isn’t currently possible. I’d recommend adding it to the idea exchange You may be able to add a default page filter and update it daily or weekly or whatever the update frequency is. Not ideal but might get you something close. Adding a…

Do you want users to instantly gain access or should it go through a review? Should the request come through Buzz or via another option? A quick and dirty option is to use the mailto protocol in an HTML hyperlink where you can specify to, subject and message body so you can send it to an automated email box: <a…

I stand corrected. Thanks for sharing @colemenwilson. Time to review all of the new datasets in the Domo Stats.

Currently scheduled reports can't get the background changed. Brand Toolkit (premium) does allow for adding in HTML code for the header and footer in the email templates but the background isn't an option.

Currently there isn't a dataset with this information. I'd recommend adding it as an idea to the idea exchange.

If you can have all of the records from your top dataset in your output dataset then you can do a left join on your dataset instead of an inner join. Then in your card do a count of the id file from your TEST dataset to get the total records that match if you just want the entire count then I’d recommend running your TEST…

This KB article may be of help where it outlines the different functions and their formats:https://domo-support.domo.com/s/article/360043429933?language=en_US SUBSTRING(`Column`,[START POSITION],[NUMBER OF CHARACTERS TO EXTRACT])

I'd recommend structuring your data with a date dimension so you can easily determine the last year's value. I typically do this with the Domo date dimension dataset. I've written up on how to do this before here:…

You can utilize the STR_TO_DATE function and a date format string to convert it to a date. STR_TO_DATE(CONCAT(`Year`, '-',`Month`), '%Y-%m') I'm adding in a concat to add the year and month together as a string to then format. From the documentation: STR_TO_DATE Converts strings (that Domo does not recognize as dates) from…

Have you tried setting the update method on the connector dataset to be Append instead of Replace so it'll append each day's run to your dataset? Alternatively if you're worried about duplicated records you could utilize a recursive dataflow (KB Article: https://domo-support.domo.com/s/article/360057087393?language=en_US)…

Are you including the 'api' portion of your url in your request?