GrantSmith Coach

@KelvinoY You'd utilize a Dataset View (Beta) or a DataFlow to join the two datasets together. There's a DataSet ID you can utilize in the governance datasets to filter for your specific one. It's a 32 digit hexidecimal (letters and numbers) value. You can get it from the URL when viewing the dataset in Domo.

Hi @nicangelica What you're looking to do isn't quite possible since you'd need to do a window function inside a window function to determine if that record is duplicated or not within your dataset. @rahul93 The card will fail to load if you're using any other aggregation on the other datasets. While that is correct SQL…

You'd need to pivot your data yourself then outside of a pivot table card (using a dataflow or other mechanism) and utilize a standard table card with your pivoted data

Hi @user074136 Domo doesn't allow for different data types in the same column. To get around this you can utilize a beast mode to customize the formatting of each row manually with several CASE statements: CASE WHEN `row name` = 'Gross Retail Revenue` THEN CONCAT('$', ROUND(`value`, 2)) WHEN `row name` = '% Retail…

Thanks for the workaround @Jaketh13 !

@jaeW_at_Onyx if a customer only purchases product 1 then they'd appear in the count which isn't desired. @user046467 The easiest option would be to utilize an ETL to filter your dataset twice (one for each product) then inner join back together based on email address from your product 1 and product 2 filter outputs and…

Have you tried passing in the id of your custom role instead of the string name?

Hi @faisalnjit I've utilized a browser plugin to refresh the page on a scheduled time for some dashboards I've configured. Alternatively you might be able to utilize a publication to do a slideshow of separate cards and cycle through them on a timer (this doesn't support pages currently though).

@user046467 How are you displaying your information? Are you wanting to just show a list of customer? What if someone buys product 1 twice and product 2 twice? Do they count as 1 or 2 in that case?

Hi @b_rad Are you wanting just the single point displayed or that value for all of your dates? If you want it for all of your dates you could utilize a window function to calculate the maximum value. MAX(SUM(`value`)) OVER ()

Hi @user018766 Currently no, you can't conditionally filter a dataset based on values from another dataset with different column names.

Hi @Rvannoy You can utilize a beast mode to calculate different buckets to then allow a checkbox selector to utilize. If you're looking for date manipulation I did a writeup and video of this a while back for the IDEAs conference. You can refer to…

@swagner Since beast modes don't support regular expressions you'll need to do it within an ETL. The JSON code I posted above will give you the starting point for a Replace Text tile in a Magic ETL 2.0 dataflow. You can copy that second code block and then just paste it when in the ETL it'll put that tile in for you with…

Hi @swagner Alternatively you can utilize a regular expression in a Magic ETL Replace Text tile (not exactly what you asked for but wanted to share just in case you wanted to go this route): ^.*-([^-]+)$ This will handle any number of dashes in your string. Copy and paste this into your Magic ETL:…

Hi @AnwarBham Short answer is no, there isn't something to easily determine the lineage of a field. There is the dataset lineage tool on the dataset which will show you where the overall dataset is used but nothing specific to a field. The closest you could get is possibly using the governance dataset "Dataset Schemas with…

Hi @leeloo_dallas Taking your sample excel file from https://dojo.domo.com/discussion/comment/53717/#Comment_53717 and as they mentioned in that ticket, you can take the cumulative sum taking unbounded to 0 following to calculate the running total then divide that by the overall total to get your contribution percentage.…

Hi @faisalnjit You'll want to talk with your CSM to see if they can turn off the sending of emails. This would require a backend change on the Domo side.

@Jessica It depends if you're wanting to ignore duplicate records or not and how you're pulling in your data. If you're using Workbench you could utilize and UPSERT to overwrite existing records or an APPEND to just tack on the result set to the existing domo dataset. Another option would be to utilize a dataset copy…

That's been a restriction for a while. Has your dataset recently grown in size?

+1 for Magic ETL Scripting tiles. It is a premium feature but you can discuss it with your CSM. They work well for this exact use case

You'll need to URL encode your special characters. There's several websites which can do this for you if you're not certain how to do this on your own. Try this: https://url-decode.com

Hi @swagner Are you utilizing pfilters with your links? Are you linking to a card or a dashboard?

@user030156 It's a Beta feature. Talk with your CSM to get the process started about getting it enabled in your instance

Alternatively you can use a beast mode and window functions to determine which row is the latest with something like: SUM(SUM(1)) OVER (PARTITION BY machine_name ORDER BY last_sync DESC) Then you can just filter this field for records with a value of 1.

@MrDomo That's good to hear, please make sure to update this when you know more information for others who may have this same issue.

You'd want to look at the Salesforce API documentation to verify what information it's pulling in and compare that to what you're expecting with that report. If it's not matching the API you'll want to talk with your CSM about the issue as it's pertaining to the connector itself.

Each individual channel will have their own "username" which you need to use to login to YouTube to authenticate and pull your data, not the admin username.

Exactly.

Hi @MrDomo Do you have an enterprise account and you're wanting to pull the specific channel's videos? YouTube makes it a bit difficult as you have to log in / authenticate as the brand page account and not the enterprise account. You account name would look something like *****-###@pages.plusgoogle.com. It'll be the same…

I'd recommend using a magic ETL to pivot your data into the table format you have above and then use a formula tile (Magic 2.0) to calculate if the answers are the same. You could do this calculation as a beast mode on the card as well but since you're already in the ETL it's better as the card doesn't have to process your…