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()))
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 = '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()))
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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive