GrantSmith Coach

@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

Hi @user005531 If your data is summarized and you're not able to drill down correctly you might look into utilizing pfilters and a hyperlink to go directly to a different card and have it automatically filtered. You may find these helpful:

Hi @Salmas You're doing an aggregate of an aggregate (SUM OF MAX) which Domo doesn't like. I'd recommend going with a Date Dimension or LAG function as @jaeW_at_Onyx has outlined above.

Hi @user015090 You can get the video views using the YouTube Enterprise Advanced Connector with the following settings: API: Data API Report: Videos It will be in a field called statistics_viewCount for each individual video.

Hi @user015090 It should scale fill your background and it should support any standard image type

Hi @user015090 It looks like the Twitter API doesn't give you a count of followers for each month. You can utilize a recursive dataflow to have your twitter dataset as an input, group based on the BATCH_RUN timestamp (you can convert this to a date or just a year and month). Group by this year & month value and count the…

Hi @loganherzog You can't utilize the Workbench SDK (I'm assuming you mean the wb.exe executable) to automatically ingest jobs. You can use the UI to import jobs that were previously exported however you'd need to make sure your IDs are unique otherwise you might have two jobs overwriting the same dataset. You could…

Hi @user009937 Currently this isn't an option. PDP only filters based on rows.

Hi @gespindola I'd recommend you restructure your data such that you have one record for each day and opportunity. You can do this by using the Domo date dimension table (Connector -> Domo Dimensions - Select calendar) and a mysql DataFlow (Magic doesn't allow between joins yet) A pseudo example would look like select…

One thing to be careful of though with IFNULL is that if Vessel happened to have a value of Y It would also be excluded. I'd recommend using @MarkSnodgrass 's version using an explicit IS NULL check or alternatively combining your '' check and the NULL check together since you do have an explicit string you're wanting to…

@Gijs Beast mode calculations don't propagate through the query API. You'd need to either include the actual calculation in your query or you would need to create a Magic ETL DataFlow, calculate it there and then use the resulting dataset in your query.

@smcclellan There's two options. One is a Domo Webform which users have to go to the dataset and enter their information into the sheet which doesn't require pulling data from a third party and waiting on that transfer. It's kept up to date instantly. The other option is similar but doesn't require users to go into the…

Hi @Rvannoy How are you filtering your data? Are you using the checkString column or the Vessel column? I'd make sure to filter based off the checkString column as it's easier to maintain. You may also gain some advantage by wrapping your Vessel column in a TRIM function to remove any leading or trailing whitespace. CASE…

Hi @user041053 Have you tried using the Linked In Ads Connector?

Hey @DuncanDomo Thanks for the contribution. Great writeup. One question I had was have you thought about just doing a join on the date table and your start and end dates? select * from calendar_dates d left join events e on e.start_date >= d.date and e.end_date <= d.date

Domo was having some connectivity issues yesterday which were impacting some of my API scripting but it appears to have been resolved now.