December 1, 2022

california cargiver

Awesome Business

Evaluating Month and 12 months Information the use of Beast Modes

1 min read




 / Evaluating Month and 12 months Information the use of Beast Modes in Domo
















Downside Observation: You will need to be capable to examine one month or yr to every other and make sure that they’re equivalent. This calls for us to both cover the present month from a card because it isn’t whole, or display the job in every month via the similar cut-off date. For instance, if it’s the 15th of the month, simply display the primary 15 days of job in every month. We didn’t need to manually regulate playing cards every month or have to provide an explanation for why a month appears so other from every other month.

Answer Observation: I used to be ready to resolve this drawback by way of developing two other beast modes for the 2 other eventualities. If I need to exclude the present month from a card, I create a beast mode that appears on the date within the dataset and tests to peer whether it is lower than or equivalent to the remaining day of the present date’s earlier month. Whether it is, then I assign it a price of “come with”, differently I assign it a price of “exclude”. I put this beast mode in my clear out and clear out to incorporate. This is the beast mode:

Beast Mode for together with finished months

CASE WHEN `EntryDate` <= LAST_DAY(DATE_SUB(CURRENT_DATE(), period 1 MONTH)) 

THEN ‘Come with’

ELSE ‘Exclude’

END

If I need to handiest display job via the similar cut-off date every month, I make the most of the DAYOFMONTH serve as to guage whether or not the day is lower than or equivalent to these days’s day. I then come with or exclude and drag it into the clear out similar to my different beast mode. This permits us to peer how the present month is trending in comparison to the similar cut-off date as earlier months. This is the beast mode:

Beast Mode for together with handiest as much as the similar cut-off date of every month

CASE WHEN DAYOFMONTH(`EntryDate`) <= DAYOFMONTH(CURRENT_DATE()) 

THEN ‘Come with’ 

ELSE ‘Exclude’ 

END

Demo: I created a video that demonstrates the right way to use every serve as:













Copyright © All rights reserved. | Newsphere by AF themes.