Conversion by amounts in the report

what do you mean not correct? what formula should it be?

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.

Good afternoon! The question on conversion in the report is not closed.

[quote] Dobrovolskaya Lyudmila wrote: Good afternoon! The question on conversion in the report is not closed. [/quote] 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

We use the functional average - which should calculate the average value by quantity. According to the screenshot, we see [file]8637[/file] 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 [file]8638[/file] 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)

[quote] Dobrovolskaya Lyudmila wrote: We use the functional average - which should calculate the average value by quantity. According to the screenshot, we see [file]8637[/file] 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 [file]8638[/file] 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) [/quote] 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)

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 ?

[Ustimenko Igor #9] Why, didn't they do anything according to the formulas?

The food is not better (

[quote] Dobrovolskaya Lyudmila wrote: The food is not better ( [/quote] 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.

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