1b.app
Link copied -

Conversion by amounts in the report

Answers:

what do you mean not correct?
what formula should it be?
11.06.2021, 16:09
Original comment available on version: ru

Conversion by number of hits and sales: divide the number of sales by the number of hits and multiply by 100.
Conversion based on the sum of hits and sales: divide the sum of sales by the sum of hits and multiply by 100.
14.06.2021, 13:32
Original comment available on version: ru

Good afternoon! The question on conversion in the report is not closed.
08.07.2021, 10:37
Original comment available on version: ru


Dobrovolskaya Lyudmila wrote:
Good afternoon! The question on conversion in the report is not closed.

formulas in the report you specified yourself
Can you give an example of what is wrong with your calculation? after all, you yourself indicated the formula and the fields in it there, and now you say it is not true, but what is not true is not clear
13.07.2021, 16:12
Original comment available on version: ru

We use the functional average - which should calculate the average value by quantity.
According to the screenshot, we see

that chat total processes 190
44 - was transferred to orders
4 - was sold
44 and 4 is simply the sum of the order values in the respective fields. That is, when the process reaches a certain stage, it is written in the required field = 1
And the challenge is just to divide 44 by 4
and it always divides by the total number of processes in our case by 190 and not by the desired number
here is the report
https://box.generator.ua/admin/report/designer/7/view/
and here is the formula

Total:
How by the existing functionality or improvement - we can find out the conversion (divide the numbers in the report by each other, and not by the number)
namely add. field (sold) and additional field (orders)
23.07.2021, 09:41
Original comment available on version: ru


Dobrovolskaya Lyudmila wrote:
We use the functional average - which should calculate the average value by quantity.
According to the screenshot, we see

that chat total processes 190
44 - was transferred to orders
4 - was sold
44 and 4 is simply the sum of the order values in the respective fields. That is, when the process reaches a certain stage, it is written in the required field = 1
And the challenge is just to divide 44 by 4
and it always divides by the total number of processes in our case by 190 and not by the desired number
here is the report
https://box.generator.ua/admin/report/designer/7/view/
and here is the formula

Total:
How by the existing functionality or improvement - we can find out the conversion (divide the numbers in the report by each other, and not by the number)
namely add. field (sold) and additional field (orders)

average works like this:
For example, there are 3 processes, process 1 has sum = 150, process 2 has sum = 200, and process 3 has sum = 550.
then average will be calculated like this:
(150+200+550) / 3 = 300
3 is the number of processes.
What did you stick to yourself that the number of processes is an additional field ... and also claim that this is an error I don’t understand)
23.07.2021, 17:30
Original comment available on version: ru

Well, this is not a mistake in your understanding - how to make it work as we need?
It is necessary to make the number of processes total for the number of fields that have additional. field = X
That is, there are 100 processes, of which 10 have the value = 1 in the x field
And B 15 in the field Y \u003d 1
Does that mean it needs to be improved or something? So that in the report it was possible to divide 15 by 10 in the grouping and get the total value in the grouped report ?
26.07.2021, 17:07
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
Ustimenko Igor Why, didn't they do anything according to the formulas?
19.07.2022, 13:22
Original comment available on version: ru



Dobrovolskaya Lyudmila wrote:
The food is not better (

I'm willing to take on a solution if they give an actual example and cover my time if there's no bug in the code.
30.07.2022, 15:35
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
Well, here we will probably work a little more, if we don’t please, but the consultation may be completed. As a result I will write
16.08.2022, 13:38
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