Hi there,
I built a question (A) with a field filter. I would now like to create another question (B) that simply counts the number of records in question (A) for a dashboard including both questions. The reason I am asking is because, if I copy-paste question A into B, it works but if I reference question A, then it throws in an error as per below.
Thanks a lot!
Below works flawlessly but..
with customer_not_reached_out_ng as (
## the actual SQL query ##
)
select
count(*)
from
customer_not_reached_out_ng
.. but below throws an error (ERROR: syntax error at or near "select" Position: 1817
)
with customer_not_reached_out_ng as (
{{#267}}
)
select
count(*)
from
customer_not_reached_out_ng