https://www.growthbook.io/ logo
h

hundreds-belgium-41942

01/25/2022, 3:01 AM
Hi, why can't I see data preview for some metrics that have setup? I've setup 3 metrics and data preview is available only on one. No data is shown on the other 2. Attaching a screenshot of one of the metrics.
f

fresh-football-47124

01/25/2022, 3:02 AM
what does the query return? can you share what it says when you click view queries?
h

hundreds-belgium-41942

01/25/2022, 3:03 AM
Thanks for the reply Graham. Attaching a screenshot
f

fresh-football-47124

01/25/2022, 3:07 AM
did you set up the "Pageview" query?
8 minutes to run!
h

hundreds-belgium-41942

01/25/2022, 3:08 AM
Yes
f

fresh-football-47124

01/25/2022, 3:13 AM
@future-teacher-7046 can you help debug?
f

future-teacher-7046

01/25/2022, 3:16 AM
The SQL you entered for the metric. If you run that directly on redshift (with a limit) do you get rows back within the past few days?
h

hundreds-belgium-41942

01/25/2022, 3:20 AM
I need to check this with one of my team members and will get back to you asap
@alert-france-37066 can you help me here
3 Views