GrantSmith Coach

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.

@AmedeoM You're indeed correct there was an issue with future dates. Your version corrects this issue and I've updated the beast mode on the dojo instance. Thanks for your contribution!

I think I misunderstood your request. I thought you were asking about having the card allow you to change some value and it would update which it can't do. If you're wanting to just open a new link that's something that is possible. I've done a write up on it here using the HTML anchor (A) tag:…

Hi @JustinB You'd need to use an dataflow to pre-aggregate your data. You can do this in Magic ETL with the group by tile.

Try this one: CASE WHEN LASTDAY(`Date`) = LASTDAY(CURRENT_DATE) THEN 'No' ELSE 'Yes' END Here's a writeup I did on the LASTDAY function if you want to read more:

@Pklassen To my knowledge you can't dynamically change the iframe size based on the amount of data so if you have too little data in a table you'll get the extra whitespace and too much data in your table will result in it getting gut off.

Hi @cedvill00 You'll want to look at the ds_query method to query domo datasets: ds_query - allows you to send a query to a data set, Domo will evaluate that query and sends the results back as a list or a tibble This will get you a result set as a dataframe to loop over like your existing method. Alternatively you can use…

Hi @Genival_Junior Sadly no, cards / beast modes don't support parameters at this time.

Hi @gbuckley Domo doesn't have parameters to pass in using this type of a method. Typically the closest you can get is using a webform to store your parameter and join that to your dataset using a dataset view. It's not the best user experience though.

Hi @Genival_Junior You're not closing your first pfilter correctly. You're leaving off the closing value code %22]} Also instead of passing in pfilter twice you can instead try and pass multiple values ni your pfilters list ?pfilter=[ { filter1 information }, { filter2 information} ] So in your example I'd remove the…

Hi @Jessica Have you tried compressing the pfilters to be on a single line instead of multiples? Also, try target="_blank" instead of URL encoding the quotes target=%22_blank%22

Hi @mberkeley You'd need to pre-calculate the total in another DataFlow or dataset view such that you have column value for the population total to compare against when filtering records. I'd recommend using a DataSet View (in beta) and then use a window function to get the entire total for the dataset and put that value…

Hi @msharma Because the way pivot tables behave and the fact that subtotals are an all or nothing setting what you're looking to do isn't possible at this time.

With a MySQL no, there isn't a way to transfer only a part of your dataset, it needs to transfer everything over to read. The best option is as I said, removing the transfer portion with a dataset view. There is a premium feature called Adrenaline dataflows which do the ETL work inside the adrenaline layer instead of…

Hi @user03781 Have you tried using a LAG or LEAD window function? They'll get you the value from the row before or after respective You can then take the rank difference between the two dates. I did a write up on them here: https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages

Hi @imelendez The biggest improvement you'll see in processing time is if you can switch off of MySQL ETL Dataflow. It's procedural so everything must be run in order. It sounds like though your MySQL ETL isn't doing much except a simple transformation. Have you looked into possibly using a Dataset View (currently in beta…