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.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 605 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 696 Beast Mode
 43 App Studio
 39 Variables
 660 Automate
 170 Apps
 442 APIs & Domo Developer
 42 Workflows
 6 DomoAI
 33 Predict
 13 Jupyter Workspaces
 20 R & Python Tiles
 388 Distribute
 111 Domo Everywhere
 271 Scheduled Reports
 6 Software Integrations
 113 Manage
 110 Governance & Security
 9 Domo University
 31 Product Releases
 Community Forums
 40 Getting Started
 30 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive