GrantSmith Coach

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

Hi @JustinB You could abstract the core calculations in a dataset view and then use that as a field in your beast mode. It's not ideal and abstracts the logic to multiple places. I've been requesting beast modes behave like actual variables for a while now instead of inserting the entire formula.

Depending on how you count your weeks you could also calculate the first day of the week or the last day of the week so that you have a continuous week and not have issues with the start / end of the year. This is assuming you'd count a week that started on 12/30/2020 as the last week in 2020 and would include 12/30/2020 -…

Hi @mhouston There isn't a way to tell the Domo connector to only bring is X% of the dataset. It's all or nothing currently. Depending on how technical you or your team is you may be able to utilize some of the internal Domo APIs to pull a subsection of this data and then upload it to your instance, however it's not really…

@Anna Yardley I've completed it as well.

Hi @faisalnjit Domo has a connector called Third Party Data Governance. There's a lot of helpful and useful information as they have datasets for the Cards, Pages, Datasets etc within Domo and how they interact with others. Here's a KB article outlining the connector:…

Hi @Jobur No, it's a separate connector. (Data -> Cloud App -> Search for webform)

Hi @Jobur You can utilize a Web Form if you want to give users the ability to edit a form like an Excel file which is included by default. There is also a premium feature to do inline editing which has an extra fee associated with it. Since it sounds like you're wanting to write back to the Hyperion system you might want…

@user048760 If you just want to display your date in a different format you can utilize the DATE_FORMAT function within a beast mode: DATE_FORMAT(`dt`, '%b %d, %Y') This way you have a single date column in your dataset and don't need to worry about maintaining both throughout your ETL process. See…

@user047019 How are you grouping your dates in analyzer? Are you showing it by day or none or by week?

Hi @sem There's a new beta available to allow filtering on aggregates. You should be able to utilize that with your beast mode. It is in Beta so you’d need to get signed up for the beta program. Start with taking to your CSM.

@user048760 What exactly are you wanting this date to represent? As you said you already have the batch last run date to show when that group of data was imported. Are you just wanting to reformat the date?

Hi @jrdunson You can schedule multiple reports from the same dashboard. When you go to schedule it it will keep any filters you have in place as well. You should be able to just select Schedule as Report from the Share menu (box with the arrow in the upper right)

Hi @user048760 You'd need to utilize a date tile or formula tile to assign the current timestamp in a Magic ETL DataFlow.

Hi @VarunMB You could try to utilize a beast mode to assign a specific sort order value and then sort your values based on that new beast mode.

Hi @colinr Currently cards don't have a supported API to view the data from a card.