GrantSmith Coach

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

Hi @eric_tetik You'd want to reach out to Domo support as it's an issue behind the scenes on their end and they'd be able to get you a better understanding of what the issue is since they have access to those logs.

@walker_page My understanding is that they should be based on the company timezone settings of your domo instance (defined under the admin section)

Hi @mberkeley Page filters apply to all cards on the page so you can't selectively apply the filter. What you could do is utilize some filter cards (one for customer, one for industry) and chance the card interactions for each filter so it only applies to your cards individually. You might still have users using the page…

Hi John (@Jobur ) Jupyter workspace is all self contained within the Domo environment. You don't need to have anything installed locally. If you want to do your analysis locally you could get python / jupyter installed on your local machine and then utilize the pydomo package to pull data from Domo as well. Domo cards are…

Hi @HowDoIDomo Do you have some sample / anonymized data you could post to get an understanding of your data format?

+1 for the APIs. They are great for automating some tasks like this. Personally, I've used the PyDomo package and a python script to interface with the Domo API to update the user attributes.

Hi @walker_page These are unix timestamps. Typically they are jut a simple numerical representation of the seconds since Jan 1st, 1970 however in this case these are unix timestamps in milliseconds instead of seconds (just divid the number by 1000 to get the number of seconds). Language have tools to convert these easily…

@cthtcc The rows are greyed out because domo has archived off those executions so you can't restore from those versions.

Hi @gbennett You could utilize a Magic ETL dataflow and a Replace Text tile in combination with a regular expression. It will keep the original value if it doesn't find a valid email address. Here's a regular expression which will find an email within a string. (\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,}\b) You can copy and…

Apologies, I had MySQL on the brain but mean to state Magic ETL 2.0.

Hi @user025461 This is because MySQL 5.6 (version Domo is built off of) doesn't support column names longer than 64 characters. You have a few options to work around this issue. 1) Use a Dataset view (or a magic ETL) to rename your column to something less than 64 characters and then use that dataset inside your MySQL…

Hi @user06209 You can utilize window functions in a beast mode (you just need to have them enabled - talk to your CSM) SUM(SUM(`Amount`)) OVER (PARTITION BY YEAR(`Date`) ORDER BY `Date`)

@HowDoIDomo That code is for a MySQL dataflow which will generate the date dimension table for you but it's built off of the Domo Date Dimension table. You can find the Domo Dimensions connector in the Cloud App lists for data connectors. Then select the dates dimension and give it a name. In my case I called it Calendar…

Hi @user048760 What you're looking for is the CONCAT function. It allows you to add multiple columns together with constants to create a single value. If you're looking for just the URL (which you won't be able to click on but would only be displayed) CONCAT('https://xxxxxxxxxx.sugarondemand.com/#Calls/', `ID`)…

Google: CASE WHEN `marketing_source_c` = 'Google' THEN `Date_entered` END Google Paid: CASE WHEN `marketing_source_c` = 'Google Paid' THEN `Date_entered` END SPS_Website: CASE WHEN `marketing_source_c` = 'SPS_Website' THEN `Date_entered` END Essentially you'd have those three case statements in 3 separate beast modes when…