failed to convert value from string to boolean
Best Answers
-
CASE
WHEN MONTH(CURDATE()) IN ('1','2','3') THEN CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q1')
WHEN MONTH(CURDATE()) IN ('4','5','6') THEN CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q2')
WHEN MONTH(CURDATE()) IN ('7','8','9') THEN CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q3')
WHEN MONTH(CURDATE()) IN ('10','11','12') THEN CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q4')
ENDTry this. it worked for me
**edit
Actually, I was able to get your original formula to work as well. I'm not sure what is causing the error.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Raj, are you in the Filter tile's formula editor there? Filter expressions must be boolean (true/false/null). You may want to use the Add Formula tile to create your quater string, and then perhaps multiple filter tiles with expressions like
my_year_quarter = '23-Q2'
to separate your data into different sets (if that's what you're trying to do).
Also, it looks like you could benefit from theQUARTER
function in that formula:CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q',QUARTER(CURDATE()))
0
Answers
-
CASE
WHEN MONTH(CURDATE()) IN ('1','2','3') THEN CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q1')
WHEN MONTH(CURDATE()) IN ('4','5','6') THEN CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q2')
WHEN MONTH(CURDATE()) IN ('7','8','9') THEN CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q3')
WHEN MONTH(CURDATE()) IN ('10','11','12') THEN CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q4')
ENDTry this. it worked for me
**edit
Actually, I was able to get your original formula to work as well. I'm not sure what is causing the error.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Raj, are you in the Filter tile's formula editor there? Filter expressions must be boolean (true/false/null). You may want to use the Add Formula tile to create your quater string, and then perhaps multiple filter tiles with expressions like
my_year_quarter = '23-Q2'
to separate your data into different sets (if that's what you're trying to do).
Also, it looks like you could benefit from theQUARTER
function in that formula:CONCAT(RIGHT(YEAR(CURDATE()),2),'-Q',QUARTER(CURDATE()))
0 -
Good catch @rco . If this is a filter tile that would explain the issue!
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive