nitot

Smart workaround!

Is it safe to say that what I'm trying to accomplish with filter cards is impossible, and I should just use page filters? Thanks

Thanks for your reply. Since I have set up a section of page filter cards, I was hoping to make Fiscal Year one of those filters, that way users won't need to rely on two different sections of the page for filters. Perhaps I'll abandon filter cards alltogether and just go with predefined filters in the filter bar.

No apologies needed! Yes, I'm using this card as a Page Filter.

Thanks much for your reply! If I'm not mistaken, this will result in the FY Filter card only showing the one filtered value. Then for the user to change FYs, they would need to open that card, and choose a Quick Filter. Is there a piece that I'm overlooking? Example: *Click on FY Filter card

Thanks for your great ideas! I was able to make your second idea (using a Max Function & Grouping) work with the help of this other string on how to create a column with Max Date https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/ETL-Create-Column-with-Max-Date/m-p/20242/highlight/false#M2090

This is an excelent solution, thanks for posting!

This is an interesting solution, if I can't automate it I'll give this a try. Thanks!

Thanks for your help! Unfortunately there is no consistency to the nonstandard data, so I can't look for a number of characters, or a certain string.

Thanks! I did check out Google Forms, but it lacks the more advanced functionality of presenting unique fields depending on the user.

I just learned of a simple solution that works only if the source files are in CSV format. If you create a new DataSet Job for Type CSV, you can specify the source as a folder rather than a file. Then as long as all of the files within the folder are CSVs, and all have the same fields, then they are all imported as if they…

Thanks AS, are you aware of any resorces for getting started with these types of Plugins?

This looks like it will work, thanks!

I originally thought about using Beast mode, but I already have dozens of cards built and would rather fix the data than edit all of the cards to use new fields. I can't for the life of me find how to use a Select statement in Workbench, do you know if there is a guide for this? Can it be done with a Filter Transform or…

Is the SELECT statement used in a Workbench Transform, in an ETL, or somewhere else? Thanks again

Thanks! Would this Case statement be used in a Beastmode, or can this be done on the data level?

Thanks Godzilla, that did the trick!

Here is the step-by-step process for anyone else who may have a need to batch-run Jobs in a specific order. * In Workbench, make note of the Job Number for the Job that must run last* Expand the Job * Click Logs, and choose the last date on which the job ran * Look for [job:XXXX] where XXXX = Job number * Create a new…

This worked beautifully, thank you for your help!

Hi, thanks for your reply. The manual manipulation is minimal. Waiting for each upload to complete so I can start the next is a larger time waste than setting up the input files.

I've tried multiple times to make the corr() function work, even creating a very simple test dataset that matches the one I provided earlier. No matter what I try, the formula validates, but I always receive the error "An issue has occurred during processing. We are unable to complete the request at this time."Have you…

Thanks for your ideas! I'll try the first one later on. I did try using the Corr() function in beastmode, but regardless of which fields I use I keep receiving the error "An issue has occurred during processing. We are unable to complete the request at this time." I noticed that Corr does not appear in the Functions list -…