on 2025 Jan 28 8:43 AM
Hello,
I'm working on a salary/HR model, and I have a request to analyse the average extra hours done (and use it later for plan) the data I have is hh:mm.
my model by the way has a monthly granularity.
what's that best practice to handle calculations and aggregation of days, hours and minutes in a dimension or in a measure?
thank you
Request clarification before answering.
Though SAC has a Timestamp dimension I am not sure if that would be of any help in your case. The best I can think of is using Measures to store this data and may be in minutes so that you could convert them accordingly.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 13 | |
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.