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 = '23Q2'
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()))
Randall Oveson <randall.oveson@domo.com>
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 = '23Q2'
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()))
Randall Oveson <randall.oveson@domo.com>
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
 All Categories
 1.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 285 Workbench
 4 Cloud Amplifier
 5 Federated
 2.7K Transform
 91 SQL DataFlows
 577 Datasets
 2.1K Magic ETL
 3.5K Visualize
 2.4K Charting
 619 Beast Mode
 26 App Studio
 33 Variables
 609 Automate
 155 Apps
 421 APIs & Domo Developer
 31 Workflows
 2 DomoAI
 29 Predict
 12 Jupyter Workspaces
 17 R & Python Tiles
 372 Distribute
 103 Domo Everywhere
 266 Scheduled Reports
 3 Software Integrations
 100 Manage
 97 Governance & Security
 4 Domo University
 15 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 91 Community Announcements
 4.8K Archive