GrantSmith Coach

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?

@mberkeley That is correct. There was a fundamental shift with ETL 2.0 to more align with SQL handling of NULLs which give consistency but can cause issues in dataflows when converting from ETL 1.0 -> ETL 2.0

Hi @user080280 Under Admin -> Pages you can filter for the page you want (clicking on the ... in each column) and then select the page. In the upper right hand corner there will be an Edit button. You can select Delete Page from the drop down list.

Hi @danidiaz A Page is a collection of cards. It's the link that appears on your left hand navigation. The default version just a bunch of cards listed grouped together in different "containers". There isn't any interaction between the cards. A Domo Story is a Dashboard (and a page), they're one in the same. IT allows you…

Hi @JunkDoom Domo has a Data Governance connector which has a dataset to list all of the columns on datasets. It's called Dataset Schema. You can create a table card with that dataset and filter for any records where `Column Name` contains your search string.

Hi @nicolac Can you just do a Count(`field`) in a beast mode or do a count in a group by tile (grouping by the class) in an ETL to get the number of times each class used the tool? Alternatively you could just select Count from the aggregation option on your field in analyzer.

@Otieno_Onyango Right, that's what I was saying. Your query looks like it should work just fine. I've run many similar queries. I was just trying see if you possibly had some NULL debitor_ids in your table to help explain why you're seeing nulls in that field. I'm also curious if you've run your MySQL Dataflow all the way…

Hi @Otieno_Onyango Do you have NULL debtor ids in your transaction table? What happens if you filter also for a.debitor_id is not null? You query appears correct and should get you the first transaction for a debitor (Yay for lack of window functions in MySQL 5.6).

Hi @cthtcc There doesn't appear to be an option built into the formatting of the text to allow for abbreviation so you'd need to do it yourself using a beast mode. Here's one that I typically use to abbreviate numbers in the billions. CONCAT(CASE WHEN LENGTH(ROUND(SUM(`Number Orders`), 0)) >= 10 THEN CONCAT(…

The group by function doesn't allow you to sort your records when you're concatenating them together with a comma. You could try to use a Rank & Window tile before the group by to sort the values and calculate the row number, then attempting to do the group by on the sorted data.

Hi @user041053 You can utilize a single value text card with your data source and select the maximum timestamp of your dataset. You'd just need to make sure to include your timestamp in your dataset. You could utilize a dataflow to add the current date time as a timestamp for when the dataset is updated. Alternatively, you…

Hi @user041053 You can utilize a single value text card with your data source and select the maximum timestamp of your dataset. You'd just need to make sure to include your timestamp in your dataset. You could utilize a dataflow to add the current date time as a timestamp for when the dataset is updated. Alternatively, you…

@Jessemauser How are you not having any luck?

Hi @user048760 Since Domo doesn't support direct connection with Google Ads it's a bit tricky to get the data ingested. I ended up writing a python script to interface with the Google Ads API to pull the data and ingest the data using the Domo API (via the pydomo Python package).

I don't think there's an actual Behavior Flow dataset from Google Analytics, you'd likely need to pull the raw data and create it yourself.

Hi @dmurgit1 You can't simply sort the aggregated string. You'd need to split your string into separate column then pivot those columns into rows, sort then and then reassemble them using the reverse process.