Forum Discussion
Trying to Add External Data available to create a Measure
Super UserHi Anonymous ,
How is the ERP file setup for the hours calculation? You present the classification but the question I posing is if there are in that file the additional data as tech, number of hours and date?
Based on the overal request you should not have the need to add the tech/available hours per month table since to what I can see everyone has the same number of hours available so the firts table that you present is sufficient to make it dynamic.
Can you share a small sample of data?
Hi! Sorry for my late response!
For the Hours calculation i created a calculated column that joined the worked hours and the Km transformed to hours
in the Horas Totales Column because are used to count as work hours.
Here you have an example of the tables , etc i use, please let me know if you need more info.
| LEEEID | LEDATW | LELABC | LEDDES | Horas Totales |
| 755 | 20190103 | VA | VACACIONES | 8 |
| 214 | 20190128 | FO | FORMACION | 8 |
| 202 | 20190124 | 54 | HORA CAMPO | 8 |
| 202 | 20190125 | 54 | HORA CAMPO | 8 |
| 810 | 20190129 | 55 | HORA TALLER | 8 |
| 810 | 20190130 | 55 | HORA TALLER | 8 |
| 881 | 20190206 | 55 | HORA TALLER | 8 |
| 881 | 20190118 | 35 | KILOMETROS | 7,5 |
| 810 | 20190108 | 38 | KILOMETROS | 3,125 |
This is the JLE_JSB Table
And this is the JEG Table where the Technicians are recorded
| EGGEEID | Técnico |
| 755 | Javier Cobas |
| 810 | Joaquin Cerecedo |
| 881 | David Caballero |
| 214 | Aida Rodriguez |
| 202 | Juan Pereira |
I Also have the Calendar tables explained in the previous post, if the first table is ok, perfect.
And here also you have the relations between the different tables
And here you have the measures that i have created
The Idea is to substitute this measures for other that automatically calculate The available hours and the non signed hours when selecting the date in filter created for that
Many Thanks and Regards