GrantSmith Coach

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

Have you tried using a beast mode to calculate your percentage instead of just if it's a 1 or 0? SUM(CASE WHEN [logic for is closed] THEN 1 ELSE 0 END) / SUM(1) Use that in a horizontal bar chart as the display text but the closed opportunity count as your x value. Make sure you use your Lead Source as the series.

Hi @user094816 I don't believe Domo's API supports pagination / chunking data. You could utilize the API to read the entire dataset and then use your python script to do the splitting logic yourself.

Hi @jgospel It's because of the extra columns you have displayed in your chart. Because you have Compliance Error, question_max_score and answer_value it's grouping by those so it's only looking at the compliance error within that specific group rather than at just the agent full name level. If you remove several of those…

Hi @user037643 Currently you can't change the owner of an account in Domo. You could try and log in as that user and share the connector account however you won't be able to make any changes to that account. Only the user that created the account can edit it. You may need to delete the account and recreate it and reassign…

Hi @user18661 This is a limitation with the Twitter API where it restricts it to the last 7 days. https://developer.twitter.com/en/docs/twitter-api/v1/tweets/search/overview. You can't specify a date range.

Hi @Ashleigh explode was introduced with pandas 0.25.0. It definitely looks like Domo has an older version of pandas. You can confirm the version they have installed using pd.__version__ I'm in agreement with @jaeW_at_Onyx . Send a ticket to support. They might be able to configure a custom environment for you with the…

Hi @jefflmp585 Domo does have an R SDK as well so you don't have to use the python SDK: https://github.com/domoinc/rdomo/

For clarification for others who might read this thread. Username and password authentication with the CLI isn't an option with Single Sign On (SSO) as you're not authenticating with Domo but rather your own system. If you used direct sign on then username and password authentication is an option.

Hi @b_rad Put the metric in the Sort section of your card in analyzer (and make sure you use the SUM aggregation on it - also select ascending or descending as needed)

You need a Token for authentication which, depending on your permissions you or an Admin would need to create on your production environment. Note that the CLI will authenticate as the user who created the token

Hi @Theodore_Mwangi They way Domo does "dynamic variables" is essentially to use a webform to allow the user to change the value and then trigger a DataFlow to reprocess the data for the visualization. There isn't a friendly way of doing this through the UI directly sadly.

Hi @user09644 As for using the pydomo SDK it doesn't expose the APIs for cards at this time. As such they're not supported. As @ST_-Superman-_ mentioned you could attempt to utilize the Java CLI and the 'delete-card' command. You might want to also use the 'backup-card' command first in case you accidentally remove a card…

Hi @rockchalk629 You won't be able to combine those three separate types of graphs however there is a Line + Stacked Bar chart which would allow you to get portions without the area piece.

Hi @PSMTQsecofr You can use a beast mode to do something similar. MySQL / Beast Modes have access to the UPPER and LOWER functions however there is no function to Proper Case a string so this defaults to "Mixed Case" if it's not either upper or lower case. It should still solve your issue of wanting to filter only Upper…

Did you convert a page to a dashboard or are you talking about a quick start app?