How to calculate the number of minutes in a month?
Does anyone know how to calculate the number of minutes in a month?
I need to calculate the number of minutes per month to deduct from them idle time also in minutes and get the percentage of accessibility of the environment.
Regards,
Rodion
Best Answers

Hi Apollo,
I just solved this by:
(DAYOFMONTH(LAST_DAY(`sys_created_on`))*1440)Thanks!
1 
Also you can just do:
DAY(LAST_DAY(CURRENT_DATE()))
This will give you the days of the current month. Then you can multiply it by 1440 to get minutes a day.
Thank you,I work for Domo1
Answers

Hi,
I found this Dojo article where they found a way to do this in beast mode. https://dojo.domo.com/t5/BeastModeETLDataflow/Isthereawaytocalculatethetotaldaysinthemonthweare/mp/14645#M1136
This calculates the number of days in a month that we are currently in. With that you can multiply it by 1440 which is how many minutes are in a day.
Thank you,I work for Domo1
Categories
 10.7K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 101 Apps
 705 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 23 お知らせ
 63 Kowaza
 297 仲間に相談
 649 ひらめき共有