Questions tagged [chartio]
3 questions
4
votes
1 answer
Set-returning functions are not allowed in CASE in postgreSQL
I am trying to run this query was able to till some time ago. I don't know what went wrong and I started getting this error now?
Your database returned: ERROR: set-returning functions are not allowed in CASE Hint: You might be able to move the…
noobeerp
- 417
- 2
- 6
- 11
1
vote
0 answers
Checking Chartio filter for empty string SQL CASE statement
In my Chartio report, I have a variable filter named TRACKING_GROUP with Control Type of Text Input, with a Default Value of the empty string.
The following SQL works fine..
SELECT
{TRACKING_GROUP} AS tg,
(CASE WHEN {TRACKING_GROUP} = ''…
Steven
- 3,526
- 3
- 18
- 28
0
votes
0 answers
Using SQL & REGEX to Clean String and Cast to Date in Chartio
I don't know too much about SQL and REGEX, especially how they work together. But I've become responsible for using Chartio to visualise data at work and need some help.
In Google Analytics, under Search Terms we capture a date range. When I pull…
Jason
- 1