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.

what does the query return? can you share what it says when you click view queries?

Thanks for the reply Graham. Attaching a screenshot

did you set up the "Pageview" query?

Yes

@future-teacher-7046 can you help debug?

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?

I need to check this with one of my team members and will get back to you asap