Comments
-
@user08845 One option is to check the Hide Date on Card Details box on the Date Range pane and the card should ignore the set date range on the page level. Maybe not an ideal solution but could work?
-
Hey @jordan_platinum That is because curdate() (at least in my timezone) is 2021-08-31 so therefore it is the last day of the month and the portion of the beastmode after the division symbol is evaluating to a value of 1 so Domo is taking the value of 1.17M and dividing it by 1. Tomorrow the value would evaluate to 30…
-
Hi Jordan, You are super close, I think you just need to change the last part of your beastmode to look like this: DAYOFMONTH(LAST_DAY(CURDATE())) - DAYOFMONTH(CURDATE()) Note, because today is the last day of the month it currently evaluates to 0 so this would give you a divide by 0 error. You may want to add 1 to the…