cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP Analytics Cloud hourly/minutely calculations

Deb_D
Participant
0 Likes
325

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

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor

@Deb_D 

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