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 
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
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 602 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 697 Beast Mode
 43 App Studio
 39 Variables
 658 Automate
 170 Apps
 441 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 32 Predict
 12 Jupyter Workspaces
 20 R & Python Tiles
 386 Distribute
 111 Domo Everywhere
 269 Scheduled Reports
 6 Software Integrations
 113 Manage
 110 Governance & Security
 8 Domo University
 30 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive