GrantSmith Coach

Hi @ktranstudent Domo allows you to upload custom SVG files with defined regions to create a custom visualization. Essentially you define where the buckets are displayed and Domo takes care of the calculating the buckets. For more information on this you can refer to this knowledge base article:…

Hi @the_tree What value do you get as the summary number? What value are you expecting?

@Kumar619 If you're looking for descriptions on each column and the tags associated with each column on your dataset you could utilize the "Dataset Schema With Tags" dataset (for clarification these tags are the ones on the columns and not on the dataset).

Hi @Shumilex Have you also tried using a different function to get the time difference in seconds like UNIX_TIMESTAMP? SEC_TO_TIME(AVG(UNIX_TIMESTAMP(`closedDate`) - UNIX_TIMESTAMP(`createdDate`)))

Hey @Ashleigh The data governance datasets do have the ability to identify the dataset type (it's the data source type on the dataset.). You can just filter for 'workbench-odbc' to get the workbench odbc jobs. I use this to filter for additional governance checks I have in place. You can then utilize those filtered…

Hi @user048760 You'd need three separate beast modes, one for each source. You just need to include the condition to filter the appropriate source in your YOY, MOM etc calculations. For example for Google: (These are all untested code) Inquiries COUNT(CASE WHEN year(`Date_Entered`)=year(curdate()) AND…

Hi @user027926 For future reference you can use the the Replace Text tile with a regular expression and replacement variables. You just need to tell the Search Term field that you're using a regular expression. Also replacement variables are in the format of $1, $2, etc instead of the traditional \1 or \2 like some other…

Hi @user048760 The amount would be the column in your table that contains the MTD amounts in your table. It's the column name. What @jaeW_at_Onyx is suggesting is that you split out each source into its own beast mode. For example: Google: sum( case when marekting_source = 'Google' then `Current MTD Amount` end ) Google…

Very helpful @Anna Yardley! Thank you for putting this together.

Hey @MarkSnodgrass I don't believe there's a way to control the abbreviation of the data columns, only the abbreviation on the graph.

Hi @Bwaalsh 1) It sounds like you're wanting to do a windowing function. This is possible within Domo as a beast mode however you need to have the feature switched on in your instance. If you don't have it you'll need to talk to your CSM. Something like: SUM(`Sales`) / SUM(SUM(`Sales`)) OVER (PARTITION BY `Color`) 2) Domo…

Hi @user055174 You could also utilize the last_day function to make it a bit simpler. LAST_DAY just returns the last day in the month for a given date. CASE WHEN LAST_DAY(`dt`) = LAST_DAY(CURRENT_DATE()) THEN 'This Month' WHEN LAST_DAY(`dt`) = LAST_DAY(DATE_SUB(CURRENT_DATE(), interval 1 month)) THEN 'Last Month' WHEN…

Hi @user047019 What you'd need to do is "stack" your data into a single dataset where you'd have the amounts calculated and then depending on the filter you have selected it will then select the appropriate records. Date | Currency | Amount 1/1/2021 | ¥ | 10000 1/2/2021 | ¥ | 5000 1/3/2021 | ¥ | 250000 1/1/2021 | $ | 10…

Hi @user084060 This is because the MySQL backend in Domo is based on MySQL 5.6 which doesn't have window functions. They were later added with MySQL 8.0. I'd recommend you look into Magic ETL 2.0 which has a Rank & Window tile which you can use LAG functions and is typically much more performant than MySQL / Redshift if at…

Hi @user048760 This is because you don't have an else clause so any record which doesn't have a Walk_In lead_source would return NULL which make your entire aggregate as NULL. Try adding an ELSE 0 clause to both of your numerator and denominator case statements. SUM(CASE WHEN 'lead_source' = 'Walk_In' AND 'unit_rented_c' =…

Hi @johnmurphy11 Welcome to the Dojo! Sadly you can't filter on a column in one dataset and then cause Domo to filter the page on a different column on the page. To get around this you'd likely need to create a Dataset View (Beta, talk with your CSM to get started if you don't have it) - Alternatively you could do this is…

Hi @GuitarMan2020 Have you tried utilizing a Beast Mode to calculate the Hour of the day: HOUR(`Date`) And then using that as your x-axis which selecting last week from your date range selector and then just doing an average of your total tickets? Since you have multiple priorities for each hour you might need to…

Hi @user095063 You could write this as a beast mode on your card as it can support window functions (assuming you have the feature enabled - if not talk with your CSM).

Hi @user084060 I'd recommend simplifying your beast mode so you don't have so many nested case statements. You can have multiple WHEN statements in your when clause. You don't need to create a new case statement in each else clause. Try something like this: case when (sum(case when product='nx' then `score` else 0 end) /…

The abbreviated beast mode is doing the SUM already for you and adding in the M (if it's in millions). Because it's adding in the extra "M" it's treating the resulting data type as a string. You shouldn't need to select the SUM aggregation from the column as it's done inside the beast mode.

Hi @Shumilex You can use a Magic ETL to join the two dates together using a Join tile based on the two dates to get a resulting dataset. After the join you can use a Select Columns tile to only select the columns you want and to rename them appropriately. You could also do this with a DataSet View if you're familiar with…

Hi @AJ2020 Here's a link to how I've done textual abbreviations via a BeastMode. https://dojo.domo.com/t5/Card-Building/Textbox-formatting-using-Concat/m-p/50397/highlight/true#M7284 You'll want the bottom example.

Hi @user084060 Here's a helpful summary from someone at Domo which explains the issue in greater detail. Permalink Also, here's a link describing the issue from the knowledge…

Hi @user12621 I like to use the UNIX_TIMESTAMP function on both timestamps and some simple math to determine the number of seconds between the two different timestamps. I wrote a prior answer on this and how to format it into days hours minutes and seconds.…

You can create custom column calculations using a Beast Mode / Calculated Field. Here's knowledge base article with some more information on those. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode If you're wanting to know how to do it across the entire data set then…

Hi @user069636 Try using a Group By tile before your Rank & Window tile to group by the product and store and use the SUM aggregation on your necessary fields

Hi @user069905 What are the file types of the two files? Have you tries saving your scan in an image format (GIF, JPG, PNG) instead of as a PDF and using that?

Also to clarify this also gives you the give you the flexibility to do a "Starts With", "Ends With" or "Contains" depending if the percent sign is at the end, start or both ends respectively. For example of the Contains column: Starts With: Prefix% Ends With: %Suffix Within: %Contains% (as shown in my prior example)

Interesting scenario! We can solve this by still utilizing a web form and utilizing a DataSet View (could also do similar logic in Magic) Your webform would look something like this: ContainsValue%AMC%Auro Medical Center%SYS Sol%Syndia Solutions%Benjamin%Benjamin Research Group So now you have your two datasets. What we'd…

Hi @swagner Have you tried the connector with a zip file that doesn't contain a CSV with a space in the file name? Alternatively have you tried escaping the spaces in the file name with a backslash ("\ ") to see if that will resolve your error? Spaces in file names notoriously cause issues...