Current Date BeastMode/ETL// Categorize Days to Months

Reply
Highlighted
Visitor

Current Date BeastMode/ETL// Categorize Days to Months

I made a beastmode to substract the current date- a fixed date value which return in # of days. Now, I need to build a case to categorize the # days into months as I can't do it directly from the date configuration on the card. Do I require a magic ETL or a case can be build up on the same beast mode?

 

Thanks,

Jessica.

 

 


Accepted Solutions
Major Red Belt

Re: Current Date BeastMode/ETL// Categorize Days to Months

You could do something simple like divide the # of days by 30 to give you a month count.

There other option is to use PERIOD_DIFF() to get the # of months difference.

https://www.w3resource.com/mysql/date-and-time-functions/mysql-period_diff-function.php

 

At least at first glance, it sounds like either option should be feasible in a BeastMode.

 

Hope that helps,

ValiantSpur

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.


All Replies
Major Red Belt

Re: Current Date BeastMode/ETL// Categorize Days to Months

You could do something simple like divide the # of days by 30 to give you a month count.

There other option is to use PERIOD_DIFF() to get the # of months difference.

https://www.w3resource.com/mysql/date-and-time-functions/mysql-period_diff-function.php

 

At least at first glance, it sounds like either option should be feasible in a BeastMode.

 

Hope that helps,

ValiantSpur

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

Visitor

Re: Current Date BeastMode/ETL// Categorize Days to Months

Thank you!!

Announcements
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!