onth over Month chart - Formula * Days in Month

mp802377 — Mon, 13 Nov 2023 17:04:35 GMT

I need to create a month over month chart. I have successfully created a hourly and daily chart.

Formulas used:

Hourly: ($(varA) * $(varB) * $(varC)) / 3600

Daily: ($(varA) * $(varB) * $(varC)) / (3600*24)

How would I create the expression for the month over month chart? Is there something like in Excel EOMONTH where I can create the formula like:

($(varA) * $(varB) * $(varC)) / (3600 * 24 * DaysInMonth)?

Is there an option for Days in Week? I cannot use (3600 * 24 * 7) because current week might only be 1 or even 5 days.

Re: onth over Month chart - Formula * Days in Month

brunobertels — Tue, 14 Nov 2023 10:00:32 GMT

here a way to count days in month

E.g :

day(monthend(today() ) )

will give 30 for novembre

So DaysInMonth could be

day(monthend([month_field] ) )