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.
I just solved this by:(DAYOFMONTH(LAST_DAY(`sys_created_on`))*1440)
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 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,