Comparative Gage - What's wrong with my query?
Using the Comparative Gauge,
I wanted to display our performance by whether the number of impressions have increased or decreased.
Only, when I use the following window functions, I get a blank card with a downward arrow.
sum(case when MONTH(`Created Time`) = MONTH(CURRENT_DATE()) then `Likes`+`Shares`+`Comments` end)
sum(case when MONTH(DATE_ADD(`Created Time`, interval 1 month)) = MONTH(CURRENT_DATE()) then `Likes`+`Shares`+`Comments` end)
What I want to do is capture the sum of the previous month in a beastmode, then capture the sum of the current month. Only, the issue arises when I realize that the values will be smaller since the current month is not complete. So I would need to capture where we are at now in comparison to the previous month.
Is this possible?