1b.app
Link copied -

Report "Working changes" depending on the pressed Start Pause Stop buttons

You need to create a report table, where there will be: a table with columns:

Name of the consultant

Shift start date and time, break time, shift end date and time

Shift duration (end time minus start time)

Duration of breaks

Net working time (end time minus start time minus break time)

A filter is also required:

Consultant

Date (from, to)

Sample table in the photo
Original question is available on version: ua

Answers:

Good day
Implementation of such a report will take approximately 7 hours.
But for the report to work correctly, it will be necessary to enable the recording of the authorization history in the system.
Issue an invoice?
11.10.2024, 10:05
Original comment available on version: ua

Дворак Микола
Personal license
Leave a message in this thread and the user's contacts will be shown to you
Yes, exhibit.
11.10.2024, 12:45
Original comment available on version: ua


Mykola Dvorak
Papidu Digital Agency wrote:
Date (from, to)

Good day
Please specify what result you expect if there is filtering for several days:
- for each employee, there will be only 1 line in the report, where the values ​​will be summed up?
- for each employee there will be X lines (according to the number of days when he was online) with data for a specific day?
15.10.2024, 11:37
Original comment available on version: ua


Maksym Vadimovich Tyndyk
OneBox production wrote:
Duration of breaks

Also, do we count breaks by changing the status in the system (Working/Resting/Stop)?
15.10.2024, 12:27
Original comment available on version: ua

Дворак Микола
Personal license
for each employee there will be X lines (according to the number of days when he was online) with data for a specific day.
15.10.2024, 14:43
Original comment available on version: ua

Дворак Микола
Personal license
Breaks are counted by changing the status in the system (Working/Resting/Stop)
15.10.2024, 14:43
Original comment available on version: ua


Mykola Dvorak
Papidu Digital Agency wrote:
Shift start date and time, shift end date and time

Good morning.
During implementation, a question arose - how do you need to calculate the start and end date of the change?
Variations can be different - according to the work schedule, according to the history of authorization into the system (if not disabled), according to the history of changes in the system (that the user did something, went through the pages in the system, etc.)
16.10.2024, 10:09
Original comment available on version: ua

And please tell me which OneBox will need to be downloaded to for presetting and test on real data?
16.10.2024, 11:03
Original comment available on version: ua

Дворак Микола
Personal license

Maksym Vadimovich Tyndyk
OneBox production wrote:

At the current moment, it first checks the work schedule, if it is not there, then the authorization history, if it is not there, then the history of changes. Is this flexible option right for you?

Yes, it fits.
16.10.2024, 12:10
Original comment available on version: ua

Дворак Микола
Personal license

Maksym Vadimovich Tyndyk
OneBox production wrote:
And please tell me which OneBox will need to be downloaded to for presetting and test on real data?

https://hocss.1b.app/
16.10.2024, 12:11
Original comment available on version: ua

https://hocss.1b.app/app/report/desiner/2/view/?filter_user_filtershiftdatefrom=... 8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
See, were such calculations necessary?
The employee does not have a set work schedule - then it takes history
16.10.2024, 13:40
Original comment available on version: ua

Дворак Микола
Personal license
Yes. Everything seems ok. The question is, after translating the box into Ukrainian, will the data in the table be in Ukrainian?
16.10.2024, 14:10
Original comment available on version: ua


Mykola Dvorak
Papidu Digital Agency wrote:
The question is, after the box is translated into Ukrainian, will the data in the table be in Ukrainian?

We will generate translations for all languages ​​today.
16.10.2024, 14:12
Original comment available on version: ua

Дворак Микола
Personal license
Ok. Thank you
16.10.2024, 14:17
Original comment available on version: ua


Maksym Vadimovich Tyndyk
OneBox production wrote:
We will generate translations for all languages ​​today.

Already.
16.10.2024, 14:17
Original comment available on version: ua

Дворак Микола
Personal license
Leave a message in this thread and the user's contacts will be shown to you
Good day! Please tell me, is it possible to adjust it so that it counts only when the start, pause, stop buttons are pressed?
05.12.2024, 14:09
Original comment available on version: ua

Дворак Микола
Personal license
Leave a message in this thread and the user's contacts will be shown to you
Good day! Please tell me if it is possible to adjust it so that it counts only when the start, pause, stop buttons are pressed. After testing the report with the managers, it turned out that the display is slightly incorrect
11.12.2024, среда, 18:04
Original comment available on version: ua


Mykola Dvorak
Papidu Digital Agency wrote:
Good day! Please tell me if it is possible to adjust it so that it counts only when the start, pause, stop buttons are pressed. After testing the report with the managers, it turned out that the display is slightly incorrect

Good day
You and I agreed on the logic of calculating the report:

Maksym Vadimovich Tyndyk
OneBox production wrote:
During implementation, a question arose - how do you need to calculate the start and end date of the change?
Variations can be different - according to the work schedule, according to the history of authorization into the system (if not disabled), according to the history of changes in the system (that the user did something, went through the pages in the system, etc.)
At the moment, it first checks the work schedule, if it is not there, then the authorization history, if it is not there, then the history of changes. Is this flexible option right for you?

and 2 months ago you accepted everything, the topic and revision are closed.
Therefore, now I am asking you to create a new topic, where you can indicate a link to this one and show with an example exactly what changes you need to make to the current report - because it is not clear to me from your comment.
Thank you, have a nice day.
12.12.2024, четверг, 13:44
Original comment available on version: ua

Дворак Микола
Personal license
Leave a message in this thread and the user's contacts will be shown to you
create a new topic
[/quote]
Good afternoon! Thank you, I created https://1b.app/ua/forum/reports-and-analytics/18958-zvit-robochi-zmini-v-zalezhn...
13.12.2024, пятница, 12:06
Original comment available on version: ua

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