Refinement of the block of reports: Table of contacts
In such a table https://prnt.sc/107kqfy , additional logic is needed
1) Add a column - Maximum sales per month: We look at the client by the date of creation and all processes for him for the entire time from this date to the month, check which month had the largest amount and display it.
For example, a client has been with us for 2 years, in February last year he had 53,000 UAH. on orders and this is the largest figure of all time - we display it.
2) Average sales volume: we calculate the formula as the sum of all Orders from the moment the contact was created / number of months from the date of creation.
Example: a contact was created on 02/14/2020, we are looking at a report on 03/03/2021
we take the sum of all orders for this period and divide by 14 (months).
Can we add such logic to the table?
How many hours?
Original question is available on version: ru
1) Add a column - Maximum sales per month: We look at the client by the date of creation and all processes for him for the entire time from this date to the month, check which month had the largest amount and display it.
For example, a client has been with us for 2 years, in February last year he had 53,000 UAH. on orders and this is the largest figure of all time - we display it.
2) Average sales volume: we calculate the formula as the sum of all Orders from the moment the contact was created / number of months from the date of creation.
Example: a contact was created on 02/14/2020, we are looking at a report on 03/03/2021
we take the sum of all orders for this period and divide by 14 (months).
Can we add such logic to the table?
How many hours?
Answers:
Timofeev Artem Olegovich wrote:
1) Add a column - Maximum sales per month: We look at the client by the date of creation and all processes for him for the entire time from this date to the month, check which month had the largest amount and display it.
For example, a client has been with us for 2 years, in February last year he had 53,000 UAH. on orders and this is the largest figure of all time - we display it.
4 hours
but this item, due to grouping by date and summing up orders, can greatly "slow down" the report loading
Timofeev Artem Olegovich wrote:
2) Average sales volume: we calculate the formula as the sum of all Orders from the moment the contact was created / number of months from the date of creation.
Example: a contact was created on 02/14/2020, we are looking at a report on 03/03/2021
we take the sum of all orders for this period and divide by 14 (months).
3 hours
26.02.2021, 15:06
Original comment available on version: ru
Tyndyk Maxim Vadimovich
Administrator wrote:
but this item, due to grouping by date and summing up orders, can greatly "slow down" the report loading
Is there an option to immediately avoid this in development?
26.02.2021, 15:08
Original comment available on version: ru
Timofeev Artem Olegovich wrote:
Is there an option to immediately avoid this in development?
No
because what you want is not optimal and depends on the amount of data
development will not reduce the amount of data
26.02.2021, 15:09
Original comment available on version: ru
Tyndyk Maxim Vadimovich
Administrator wrote:
Timofeev Artem Olegovich wrote:
Is there an option to immediately avoid this in development?
No
because what you want is not optimal and depends on the amount of data
development will not reduce the amount of data
If you customize the report?
26.02.2021, 15:11
Original comment available on version: ru
Timofeev Artem Olegovich wrote:
If you customize the report?
what difference does it make to customize or not - your logic is "bad" (so to put it mildly)
The only option for it not to be stupid is not to do it.
26.02.2021, 15:14
Original comment available on version: ru
Tyndyk Maxim Vadimovich
Administrator wrote:
The only option for it not to be stupid is not to do it.
This does not fit. You need to make a decision to look at these indicators.
I understand correctly that the only solution with "will be stupid"
and there are no other adequate decisions other than "do not do" exactly (!)?
26.02.2021, 17:06
Original comment available on version: ru
Timofeev Artem Olegovich
Employee wrote:
Tyndyk Maxim Vadimovich
Administrator wrote:
The only option for it not to be stupid is not to do it.
This does not fit. You need to make a decision to look at these indicators.
I understand correctly that the only solution with "will be stupid"
and there are no other adequate decisions other than "do not do" exactly (!)?
everyone has different concepts of stupidity
with a good server and the right settings, it will not be stupid
26.02.2021, 17:21
Original comment available on version: ru
Ustimenko Igor
OneBox CTO wrote:
everyone has different concepts of stupidity
with a good server and the right settings, it will not be stupid
I understand. But this does not give any guarantees.
In general, the assessment is clear.
26.02.2021, 17:23
Original comment available on version: ru
Timofeev Artem Olegovich
Employee wrote:
Ustimenko Igor
OneBox CTO wrote:
everyone has different concepts of stupidity
with a good server and the right settings, it will not be stupid
I understand. But this does not give any guarantees.
In general, the assessment is clear.
Forget about the word guarantee through the forum here no one owes anything to anyone
28.02.2021, 14:52
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 2025
