need a variable or revision in the report Template tables
Previously, I was given the [countDaysAll] variable, but it is applicable when you want to see data for a meridian no more than a month (and only the current one).
you need a variable or report setting where you can get the average.
those. the variable consists of the number of days in the selected period (month). and if we look for 3 months January-February-March. Then the variable should be for January 31, February -28, March 31.
and if we do from February 14 to March 17, then it should be divided by the number of days in the period, broken down by month.
the variable is now applicable for working in one month, and when the data from 2 months is correct only in the final total, and in months they are divided by the total number in the entire period, which is greater.
I need to have an average for 1 day in a simple period. any indicator / number of days that are in the analyzed period for each month.
now the variable only allows you to see the general correct data. and by months they
Original question is available on version: ru
you need a variable or report setting where you can get the average.
those. the variable consists of the number of days in the selected period (month). and if we look for 3 months January-February-March. Then the variable should be for January 31, February -28, March 31.
and if we do from February 14 to March 17, then it should be divided by the number of days in the period, broken down by month.
the variable is now applicable for working in one month, and when the data from 2 months is correct only in the final total, and in months they are divided by the total number in the entire period, which is greater.
I need to have an average for 1 day in a simple period. any indicator / number of days that are in the analyzed period for each month.
now the variable only allows you to see the general correct data. and by months they
Answers:
Please provide a link to the report so that we can analyze for what specific miscalculations you use the specified variable and possibly offer a solution
25.06.2021, 14:01
Original comment available on version: ru
29.06.2021, 12:23
Original comment available on version: ru
I can suggest you make a variable to use in formulas that will count the number of days for each grouping period:
- day = 1
- month = number of days in the calculation month within the filtering period
- year = number of days in the year of calculation within the filtering period
Tarovik Dmitry Nikolaevich wrote:
those. the variable consists of the number of days in the selected period (month). and if we look for 3 months January-February-March. Then the variable should be for January 31, February -28, March 31.
and if we do from February 14 to March 17, then it should be divided by the number of days in the period, broken down by month.
That is, in this style of miscalculation.
This revision will take 2 hours - issue an invoice?
- day = 1
- month = number of days in the calculation month within the filtering period
- year = number of days in the year of calculation within the filtering period
Tarovik Dmitry Nikolaevich wrote:
those. the variable consists of the number of days in the selected period (month). and if we look for 3 months January-February-March. Then the variable should be for January 31, February -28, March 31.
and if we do from February 14 to March 17, then it should be divided by the number of days in the period, broken down by month.
That is, in this style of miscalculation.
This revision will take 2 hours - issue an invoice?
29.06.2021, 16:25
Original comment available on version: ru
Now, if we take the period from 05/15/2021 to 06/15/2021, then it takes the same indicator in the 5th and 6th months, and I need the number of days of the period of 5th and 6th months to be taken when calculating.
or add the output of the average in the report, although I use this for formulas and here the variable is more profitable, since it is applicable in different reports.
if the variable closes this question, then it's OK, it suits me.
or add the output of the average in the report, although I use this for formulas and here the variable is more profitable, since it is applicable in different reports.
if the variable closes this question, then it's OK, it suits me.
02.07.2021, 11:07
Original comment available on version: ru
Tarovik Dmitry Nikolaevich wrote:
Now, if we take the period from 05/15/2021 to 06/15/2021, then it takes the same indicator in the 5th and 6th months, and I need the number of days of the period of 5th and 6th months to be taken when calculating.
or add the output of the average in the report, although I use this for formulas and here the variable is more profitable, since it is applicable in different reports.
As I understand it, for May, take the number of days from 05/15/2021 to 05/31/2021, and in June from 06/01/2021 to 06/15/2021
Or I misunderstood you?
02.07.2021, 12:21
Original comment available on version: ru
This revision will take 2 hours - issue an invoice?
?
02.07.2021, 13:17
Original comment available on version: ru
improved the [countDaysMonth] variable according to the logic discussed above
08.07.2021, 12:27
Original comment available on version: ru
the report does not work after replacing the old variable with a new one
08.07.2021, 17:18
Original comment available on version: ru
https://vmk.crm-onebox.com/admin/report/desiner/4/view/?filter_order_clientmanag... A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
changed variables in settings
with the specified filtering considers:
- June 16
- July 31
changed variables in settings
with the specified filtering considers:
- June 16
- July 31
09.07.2021, 16:58
Original comment available on version: ru
I don't know if this is for a variable or a claim report. if I take a period of less than a month from 06/15/2021 to 07/12/2021, it shows me only 7 months, data for 6 months is not in the table.
12.07.2021, 14:25
Original comment available on version: ru
i.e. if from 06/12/2021 to 07/12/2021 then it already shows https://vmk.crm-onebox.com/admin/report/desiner/4/view/?filter_order_clientmanag... 06-12&filter_templatetable_dateto=2021-07-12&filter_order_deliveryid=&templateid=17&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0 %D1%82%D1%8C
12.07.2021, 14:25
Original comment available on version: ru
Tarovik Dmitry Nikolaevich wrote:
I don't know if this is for a variable or a claim report. if I take a period of less than a month from 06/15/2021 to 07/12/2021, it shows me only 7 months, there are no data for 6 months in the table.
the problem was in the report - fixed
12.07.2021, 14:56
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
