Discussions
-
Why does the percentage change calc in Beast mode show -100% all the time?
I have a beast mode calculation that calculates % change in sales but the result in domo is always -100%. Below is my bbeast mode code. Any ideas? (((CASE WHEN YEAR(Target.`ForDate`) = YEAR(CURRENT_DATE) THEN Target.`RetailSales` else 0 END) - (CASE WHEN YEAR(Target.`ForDate`) = YEAR(CURRENT_DATE)-1 and…
-
There are more results than can be shown. Try adding or changing a filter.
Does anyone know why I 'd keep getting "There are more results than can be shown. Try adding or changing a filter" when building Sumo Cards? What's the best way to avoid this error? -Steve