GrantSmith Coach

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…

@awhite , How are you attempting to display this information? In a text card? A table card with multiple rows?

You could also reach out to your CSM to see if Domo has something internally or custom they could do for you to turn this off.

Hi @gospel Are the two evaluators always the same two or will the number of evaluators be dynamic?

Using Pfilters to Apply Filters from URL Query Parameters to Embedded Dashboards This knowledge base article outlines the process and the format of the pfilter get parameter in your URL.

To expand on @jaeW_at_Onyx 's answer - The rank and window tile requires a column to order by. That's why you must add a dummy constant / column to your dataset

You can use them on Domo pages and dashboards. It'd take you to a separate card and not drill directly in place / filter your dataset on that dashboard.

Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6

Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6

Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6

Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6

Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6

Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6

Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6

Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6

Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6