Comments
-
@MichelleH Is there a way to do a filter formula to calculate without the rank and window tile. it can be in a beastmode if needed. Something similar to CASE WHEN YEAR(`Date`) >= YEAR(CURDATE()) AND MONTH(`Date`) <= ADDDATE(CURDATE(), INTERVAL 3 MONTH) THEN 'SHOW' ELSE 'HIDE' END The one problem is that it is picking up…
-
@MichelleH @MarkSnodgrass How would I go about this in a window function under the rank and window tile? or do you know what the beastmode would look like?
-
@mhouston i was using the following beastmodes above in a CASE statement using the AND function making each one IS NULL then 'filter out' else 'keep' end
-
They are fairly long which could be causing the issue... Change in Margin - 2020 to 2021: (SUM(CASE WHEN YEAR(`Period Date.1`) = YEAR(SUBDATE(CURDATE(), interval 1 year)) AND MONTH(`Period Date.1`) <= MONTH(SUBDATE(CURDATE(), interval 1 day)) AND DAYOFYEAR(`Period Date.1`) < DAYOFYEAR(CURDATE()) THEN `Net Sales Amount`…
-
@GrantSmith Always best to talk something through haha...yes that makes total sense now. Thank you for your help on this!
-
That makes sense. Is there a beastmode that can help in this instance or should I make an etl and aggregate the columns accordingly. Thanks
-
for example:
-
@MarkSnodgrass Worked great! Thanks you for your help on this. If I was to use a rank and window to get start of day and most current of day how would I format that rank? rank by row number, timestamp descending? Thanks
-
@MichelleH Yes, I contacted them regarding this issue. I am waiting to hear back on the corrective action going forward. I will keep you updated when they reach out. Thanks
-
This worked perfectly. Thank you for your help on this!
-
Ahh..I see now and got it working. Thank you for your help Mark!
-
Yes, could be a browser issue or just this card in general, but here is a snapshot of where it should be...i see the show formatting options at the bottom but not the show more options tab that is displayed in a DOMO University task I am trying to complete.
-
When I choose Use all Values it still doesnt show the "show more options" drop down so im not sure why its not working
