need a variable in the report in order to calculate the average value
in these reports, you need to implement the ability to calculate the average value for the date or the average daily indicator for the period.
for example, indicators Turnover, Margin, profit. by filter, for example, we select for a week, and you need to know the Average by day. or you have chosen 10 days and you need an average indicator for these 10 days.
Is this in the current functionality or needs to be improved?
I need a monthly indicator for Turnover and profit, for example, the average daily. General indicator / for the number of days in the selected period. For example, we chose from 10/2/2020 to 10/13/2020 this is 11 days, respectively, we DIVIDE the indicators by 11 and get the average.
Original question is available on version: ru
for example, indicators Turnover, Margin, profit. by filter, for example, we select for a week, and you need to know the Average by day. or you have chosen 10 days and you need an average indicator for these 10 days.
Is this in the current functionality or needs to be improved?
I need a monthly indicator for Turnover and profit, for example, the average daily. General indicator / for the number of days in the selected period. For example, we chose from 10/2/2020 to 10/13/2020 this is 11 days, respectively, we DIVIDE the indicators by 11 and get the average.
Answers:
Good afternoon. In what "These reports"??
05.11.2020, 18:43
Original comment available on version: ru
05.11.2020, 21:05
Original comment available on version: ru
Bodyako Dmitry
Employee wrote:
Good afternoon. In what "These reports"??
It would be better to do it in a separate column. For the TOTAL indicator to be divided by the Number of days in the selected period https://prnt.sc/veibin
and it was like a tick in the indicators and was considered only where you put it https://prnt.sc/veiczx
06.11.2020, 10:19
Original comment available on version: ru
It is necessary to understand the average indicators for the period.
06.11.2020, 10:20
Original comment available on version: ru
We can make the number of filtered days parameter there, and you will already substituting it into the formula and divide the necessary numbers by it. Takes about 2h
06.11.2020, 16:25
Original comment available on version: ru
it will be in only one report, Process statistics for the period by status. Or in all reports of this type
06.11.2020, 16:43
Original comment available on version: ru
I'll think about whether I need it in others. I'll answer later
06.11.2020, 17:09
Original comment available on version: ru
let's just output in this report. Submit an invoice
06.11.2020, 19:51
Original comment available on version: ru
Hello. The [countDaysAll] variable works only in the "Process statistics (by status)" template
09.11.2020, 15:48
Original comment available on version: ru
she counts 1 day more. I chose from 10/01/2020 to 10/31/2020 and the indicator for 31 days should be 23991, and it is 23241, which is equal if divided by 32 days
Bodyako Dmitry
Employee wrote:
Hello. The [countDaysAll] variable works only in the "Process statistics (by status)" template
Bodyako Dmitry
Employee wrote:
Hello. The [countDaysAll] variable works only in the "Process statistics (by status)" template
09.11.2020, 16:05
Original comment available on version: ru
and if I take from the 1st to the 10th, then it correctly counts for 10 days
09.11.2020, 16:07
Original comment available on version: ru
the problem manifests itself over 30 days if it counts. Up to 30 I tried it normally thinks
09.11.2020, 16:11
Original comment available on version: ru
bras from 01.10.20 to 04.11.20 then it shows the result if divided by 36. but it should be by 35, and so it is over 30 days, up to 30 days period I don’t see a problem
09.11.2020, 16:13
Original comment available on version: ru
yes, I see - I'll look at the package in time
09.11.2020, 16:30
Original comment available on version: ru
basic works. The only negative is that if the periods are in different months, then it divides the indicators of one month by the total indicator. It's not pretty, but it's not deadly. variable feature
09.11.2020, 17:30
Original comment available on version: ru
well, that's why it's a variable number of days in a period and not a variable number of days in a particular month
09.11.2020, 17:32
Original comment available on version: ru
The variable is again invalid. We take the period from 11/19/2020 to 11/01/2020 and this is 19 days. and counts as 18 days.
19.11.2020, 10:50
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
