search

newrelic / developer-website

Source code for the New Relic Developer Site.
https://developer.newrelic.com
Apache License 2.0
40 stars 114 forks source link

[Dashboards] Correctly set NRQL to generate sign up data #1914

Closed jpvajda closed 2 years ago

jpvajda commented 2 years ago

Relates to #1756

Now that we have the ability to track new user signups, let's improve our dashboarding so we can see the following data:

Total Signups from install

Screen Shot 2021-11-23 at 3 41 46 PM a 😞 attempt ```sql SELECT count(*) as 'Sign Ups', filter(uniqueCount(anonymousId), WHERE eventName = 'TDEV_QuickstartClick_instantObservability'AND eventName = 'TDEV_QuickstartInstall_instantObservability' AND eventName = 'TLMK_SignUp_signup' AND eventName = 'TLMK_SignUp_signupThankYou' ) ```

Signup from the install funnel

Screen Shot 2021-11-23 at 3 41 54 PM a 😞 attempt ```sql FROM TessenAction SELECT filter(uniqueCount(anonymousId), WHERE eventName = 'TDEV_QuickstartClick_instantObservability'AND eventName = 'TDEV_QuickstartInstall_instantObservability' AND eventName = 'TLMK_SignUp_signup'AND eventName = 'TLMK_SignUp_signupThankYou') TIMESERIES AUTO SINCE 1 month ago ```

Acceptance Criteria

Dashboards are found here

jpvajda commented 2 years ago

@rudouglas if you are bored during 🦃 , I'd be curious to learn why my queries are not working...

rudouglas commented 2 years ago

I've changed the queries a little bit so they are showing data but i'm not 100% sure if that's what you're looking for @jpvajda lets huddle on this

jpvajda commented 2 years ago

@rudouglas you nailed it. Perfect!

jpvajda commented 2 years ago

@rudouglas actually... the data looks a bit off, so we can discuss.

jpvajda commented 2 years ago

After looking at these queries and thinking about the problem we are trying to solve by presenting this data in a dashboard, I'm going close this out we can obtain our signup count from our funnel chart for a period of time, so that should be enough for us to use for now to measure signups from I/O, there is also a tableau report that provides the data we are trying to show via NRQL, so for now we have enough to work with.

It's a little confusing as to why we are seeing different counts of sign ups depending on how we look at the data, but it's sort of a 🐰 🕳️ and it's not really our team's primary focus to figure out NRQL magic to report on this data.

rudouglas commented 2 years ago

Ye I was using a Facet cases for the newer charts so I think that just performs differently than the funnel