Philippe Hébert
04/28/2022, 2:54 PMSELECT SUM({{fact}}) WHERE {{attribute}}
I get "Can't display this insight" on all affected insights.
When I try
SELECT SUM({{fact}}) WHERE {{attribute}} = TRUE
(or = true
)
The metric edit window does not want to save
When I try
SELECT SUM({{fact}}) WHERE {{attribute}} LIKE 'true'
I get an error that LIKE is only applicable to labels
--
How should I handle this?Joseph Heun
04/28/2022, 3:15 PMPhilippe Hébert
04/28/2022, 3:20 PMMichal Hauzírek
04/28/2022, 3:44 PMSELECT SUM({{fact}}) WHERE {{attribute}} = <value selected from the list of loaded attribute values>
so you need to select the value from the “attribtue values” list (assuming we are speaking about the hosted GoodData).
Alternatively what would also work but would be much slower to use LIKE with a label, but the attribute + specific value has much better performance.Philippe Hébert
04/28/2022, 5:18 PM= 'true'
and it did not work - but I may be recollecting wrongJakub Sterba
04/29/2022, 8:25 AMJakub Sterba
04/29/2022, 8:28 AMselect SUM(fact) WHERE attribute ILIKE "true"
btw. ILIKE will ignore the case. I would however recommend to use = or IN operator rather than LIKE operator for performance reasons.