clloyd01 Member

@jaeW_at_Onyx , Your Domo YouTube content is like GOLD! I've run across a number of your solutions in my quest for knowledge. We hadn't considered that before but it's a great idea. The new Domo views feature would make having a date dimension table super handy. Thank you! Chad

Unfortunately, even adding the week ending date in an ETL wouldn't work either. The Period over Period charts forces the week beginning date vs the hard-coded date. The only option after reaching our to our CSM and PM for visualization is to manually build our own PoP cards as described in this knowledge base…

@Jarvis - We have done exactly that. Greg Pendleton with the connector team has been working with us but we're stuck on determining the type of account needed to log into the ADP connector. We've created an admin user with all permissions and we're still not able to get it to work. It's not like he's not trying to help us,…

Odd - we aren't seeing ANY data come through with any of the reports although data is definately there. I'll check with support and see if they can give us a hand.

Does this connector actually work? We've tried connecting it but we keep returning blank datasets...

Thanks for the point in the right direction!

All is well....forgot the ''s on Won....

Just for the amusement of those more familiar with MySQL...I gave it a shot but appear to be failing miserably. :( In my transform I have: SELECT a.*, ROUND(100.0 * (SELECT COUNT(*) FROM mscrm_opportunities_sales_cycle_duration AS b WHERE b. `ETL_Days_to_Close` <= a.`ETL_Days_to_Close` ) / total.cnt, 1 ) AS percentile FROM…

Sounds like a possible solution....only hiccup is that no one on my team has any experience with mySQL and I'd need to find an extra kidney to bribe anyone in our IT department to take a look at it. Any idea if the same might be possible usignmagic ETL? I was looking at some of the function options but I'm not seeing…

I guess the silence indicates that the answer to my original question is no...... :(