About Paul_Vienneau

Paul_Vienneau · 12-14-2020

If you're looking for a unique opportunity to help establish a Data Analytics team with the oversight to design, implement, and lead a group responsible for delivering on Payroc's growth and industry-changing strategic objectives - read on.At Payroc,...

Paul_Vienneau · 10-29-2020

Hello,With the hopes of restricting my result set based on a user entered value, I created a view filter with a SQL parameter - simplified for this example:filter: test_filter_sql { type: number sql: 1 = ${test_filter_sql};;}Question: How do I refere...

Paul_Vienneau · 10-28-2020

Hello,This one is a head scratcher.I have a table (VW_DATE) with one column (DATE) - Snowflake. The table is populated with a sequential list of dates - 1/1/2000 thru 1/1/2100. I want to get every 7th day starting at a base date (example below starts...

Paul_Vienneau · 10-30-2020

Thanks, Nathan - that was it.

Paul_Vienneau · 10-29-2020

Thanks, @nathaniel_t, the Explore option worked - thanks. However, I need to check for the presence of a parameter value as my FANCY_SQL_FUNCTION won't work with nulls. I’ve tried every combination I can think of to reference our_view.hi_im_a_paramet...

Paul_Vienneau · 10-29-2020

Thanks, @nathaniel_t for getting back to me. I think my example may be a bit more tricky. Using your example, let me expand.I have a view on a Date table - containing a sequential list of dates. On the view, I’m attempting to add a filter that will r...

Paul_Vienneau · 10-29-2020

thanks, but no luck - tried {{ value }} and { value }

Paul_Vienneau · 10-29-2020

Thanks, @izzymiller - that was it!!

My Stats

Paul_Vienneau's Bio

Badges Paul_Vienneau Earned

Recent Activity

Payroc is building a Data Analytics team and looking for a lead Data Analyst

Self reference Filter value

Results != SQL Runner Results

Re: Self reference Filter value

Re: Self reference Filter value

Re: Self reference Filter value

Re: Self reference Filter value

Re: Results != SQL Runner Results