GrantSmith Coach

Hi @danidiaz There isn't a public API that's supported to perform the creation of cards currently.

Hi @user000253 You'll need to define your custom sorting order as the bins are now being treated as strings and "30" comes after "280"' CASE WHEN CEILING(`number`) <= 10 THEN 1 WHEN CEILING(`number`) <= 20 THEN 2 WHEN CEILING(`number`) <= 30 THEN 3 WHEN CEILING(`number`) <= 40 THEN 4 WHEN CEILING(`number`) <= 50 THEN 5…

Hi @user000253 The histogram is fairly limited in the customization options. Currently you can't customize the number format for the bins. I'd recommend offering this as a product feedback (https://knowledge.domo.com/Welcome/Getting_Started/Submitting_Domo_Product_Feedback) You could use a bar chart and custom bin labels…

Hi @user000253 In beast modes you can use the ROUND function to round a number to a specified number of decimal places. ROUND(`number`, 0) In this case 4.1 would go to 4 and 4.6 -> 5 If you want 4.1 -> 5 then you can use the CEILING function instead which returns the next highest whole number. (For reference FLOOR is the…

Hi @JonavilCello Unfortunately Domo doesn't offer that level of granularity for their permissions structure. It's an all or nothing with page permissions, you can either edit pages or you can't.

@ravimohan911 I'd suggest reaching out to Domo Support since it sounds like an internal / backend issue.

Hi @user048760 What you're wanting to do is possible by utilizing a date offset dimension. Essentially you'll have records for each day for current, lat week, last month, 2 months ago, whatever you want to define your offset / period definitions. There's been several write ups about this specific topic on the Dojo before.…

Hey @moonmoth @Ashleigh is the resident course builder expert but I believe she stored CB stats and completions within Google Analytics and added tracking tags to the CB courses she built.

Hi @ravimohan911 Have you tried updating the embed type to Off (save) then back to Private (save)? Have you confirmed that URL is correct for that new page under Admin -> Domo Everywhere -> Dashboards?

Hi @WorldWarHulk I'd recommend you reformat you restructure your data to utilize a date offset dimension. You can have customizable offsets (in your case last quarter) for each of your dates so that you can easily do different period over period type analysis. I've written on this topic before:…

Hi @b_rad The Domo Period over Period charts have their shortcomings. You likely won't be able to format it in a tool tip because you don't have access to the last week value in your beast modeI typically use a date offset dimension table which allows me to define my own offsets like last week, last month, last year (day…

Hi @danidiaz It's not possible currently. You option is to duplicate (save a copy) the card on your dashboard and implement your different filters on the different versions of the cards and then schedule that report / dashboard to be emailed.

Hi @b_rad Are the CURRENT_PERIOD_DATE and PREVIOUS_PERIOD_DATE columns in your dataset? Do you have a sample screenshot of where you're entering this information? You might be able to utilize the DATE_FORMAT(`date_field` , '%m-%d') function to help format your dates.

Hi @user052846 You might be able to do this within a window function in a beast mode (filtering based on a case statement and the new aggregate filter beta - talk to your CSM to get it enabled). You can get the maximum average per day with the following beast mode (make sure you have date in your card or this won't work)…

Hi @mattAnonomatic I'd recommend getting in touch with Support for this type of issue. They'd be able to help diagnose your issue and if it's a problem with your account or not.

Awesome! Glad to hear it @user028768 If you could mark my answer as accepted for others to make it easier to find I'd appreciate it. Thanks!

Hi @user028768 Try wrapping your values in double quotes: CONCAT('<a href="', `Link to Additional Info`, '" target="_blank">Click to see additional info</a>') Also, what type of card are you using? Hyperlinks will only work in table cards.

Also, by utilizing a window function in a beast mode it'll properly handle any filtering done to the cards instead of doing it within an ETL.

Hi @ravimohan911 CC @MarkSnodgrass So technically you could hack it a little bit to sum all of your values together while ignoring but it gets a bit wonky as the Total row is manually calculated and would need to be a separate row in your dataset. If the user does any sorting the Total row wouldn't be at the bottom…

@jaeW_at_Onyx @banderson FYI There's a limit of 1024 characters for columns in your datasets. The text in one of my data columns is getting truncated Domo has a 1024-character limit. Any additional characters after this will be truncated. You can get around this by splitting the text between two columns to make sure it…

Hi @User_32236 500 (see https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/500) simply means an internal server error (essentially Domo had an issue processing your API request). It's an HTTP response code. Typically when I've seen 500 error in the past it's because of malformed data being sent to the API call. Have…

The version of MySQL that Domo uses (5.6) doesn't support quite a few nice features like regular expressions so you'd need to resort to something like the LIKE command as the simplest option to see if a substring exists in your field.

Hi @user077529 You can use a CASE statement to conditionally count values in a beast mode. You're close but yours is only counting everything if isRegistered is true. You want something like this: Registered count COUNT(CASE WHEN `isRegistered` = 'True' THEN `OrderNo` END) Non-Registered. COUNT(CASE WHEN `isRegistered` =…

Hi @banderson Are the items you're checking against this list the same values all the time or would they vary depending on another dataset?

Hi @user10926 What you can do is make a copy of your column into a new column and then do the replace on your new column to do the substring.

Hi @Mike_Shrift , I cases of period over period I highly recommend creating a date dimension table to join to with your different offsets (day, week, year, etc) This gives you more flexibility with your graphs. Plus if you're looking to do period over period this way give more accurate representation of the current month…

Hi @user10926 Have you tried using the replace text tile in Magic ETL 2.0? You can find the entire pattern and then just replace it with your match group number like below:

Hi @mberkeley Is it possible for a customer to have different times or are the times always the same? You'll likely need to remove the duplicates via a data flow or data view before brining it into your card to calculate your average.

Hi @jsculley Assuming rating level is a numerical column in your dataset: `Rating Level` * 2500

You just need to utilize aggregates in your beast mode to add all of the elements in the group before determining the percentage. SUM(`performed`) / SUM(`projected`) You can then format that as a percentage to display correctly. The problem with the Total Row column is that it adds everything together so if you're at 80%…