GrantSmith Coach

@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.

Hi @b_rad There is an Alpha feature where you can filter on aggregate functions within Domo but it doesn't always function as expected. You can talk with your CSM about possibly enabling the Aggregate Filtering feature but it's still in an Alpha state so proceed with care.

Hi @mberkeley You can use the Contains filter on the quick filter. You just need to make sure you set the quick filter to use the "Match Values" option in analyzer and then the user will be able to select "Contains" as the filter option.

Hi @jefflmp585 I'd recommend utilizing a Sankey chart and the Google Analytics connector for this so it would automatically update for you instead of having to download the file each time you want it updated.

Hi @b_rad You'd need to aggregate your data such that you have each value separated by "," (including the quotes) so that each value is properly escaped when you pass it in as a pfilter argument list.

Hi @danidiaz You'd need to create a new custom SVG Map to define the continent segments. Domo doesn't support conditional chart selection as part of a drill down filter so you wouldn't be able to click on a continent to list the different countries is in it.

Hi @user000253 I'd recommend using an APPEND tile in an ETL or a DataFusion to UNION your two datasets together. However one caveat to this would be they need to be in the same format / have the same columns You could process your data to look like the following: | Job ID | Country | Year | Amount | | 123 | UK | 2009 |…

Hi @user000253 In the ETL you can use a String Operations tile with the Trim Spaces operation to remove any leading or trailing spaces.

Hi @b_rad 1 - You should be able to pass in multiple filters for different columns to filter your data. It's outlined under https://knowledge.domo.com/Engage/Sharing_Content_Outside_of_Domo/Using_Pfilters_to_Apply_Filters_from_URL_Query_Parameters_to_Embedded_Dashboards Looking at your URL it appears you're passing in the…

Hi @anasahmed You can use the pivot tile in a Magic ETL dataflow to convert your row values in your 123 1 column to actual columns.

I agree with @MarkSnodgrass - You'd need to aggregate / rank the data before pulling it into your card to filter on the rank. Window functions are available in a beast mode however you can't filter based on an aggregate function in analyzer (unless you have a very alpha option to filter on aggregates but I don't recommend…

Hi @user01061 You can't dynamically set a column header in a table card. You can use a column's value as tooltip text which you can then use the tooltip macro in the hover text or data value properties but the actual column names can't be changed dynamically.

Also as a warning private APIs aren't supported by Domo so you're using those at your own risk as they could change without warning and cause issues or break your script.

Hi @walker_page I believe the actions are the different types of steps that are in your MySQL Dataflow. 'GenerateTableAction' would be the first steps when it's reading in your data for use futher down in your dataflow. 'SQL' actions are Table type Transforms or output datasets. 'SqlAction' are SQL type Transforms.

Hi @mberkeley Currently this isn't possible as Domo generates the query behind the scenes on their end based on what you click on in the card and doesn't support GET parameters (parameters in your URL after the ?). This would be a great thing and I'd recommend adding it as an idea or talk with your CSM.

Hi @LCash Here's a simplified version for calculating the number of business days since today without using the WEEK function: -- Calculate the number of actual days between the two dates DATEDIFF(CURRENT_DATE(), `date_start`) -- Subtract the days of weekends between the two dates - DATEDIFF(CURRENT_DATE() + INTERVAL (1 -…