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/Beast-Mode-ETL-Dataflow/Is-there-a-way-to-calculate-the-total-days-in-the-month-we-are/m-p/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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 772 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 78 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 143 Manage
- 139 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive