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
 283 Workbench
 4 Cloud Amplifier
 4 Federated
 2.7K Transform
 90 SQL DataFlows
 566 Datasets
 2K Magic ETL
 3.4K Visualize
 2.3K Charting
 596 Beast Mode
 13 App Studio
 29 Variables
 594 Automate
 148 Apps
 417 APIs & Domo Developer
 28 Workflows
 1 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 362 Distribute
 99 Domo Everywhere
 261 Scheduled Reports
 2 Software Integrations
 97 Manage
 94 Governance & Security
 14 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 90 Community Announcements
 4.8K Archive