Hi,
I have below 2 data source,
first:
PersonName, checkinTime,checkoutTime
lisa,9:00,18:00
linda,4:00,15:00
bob,15:00,20:00
second:
nonOfficialWoringTime
before 9:00
12:00-13:00
after 18:00
how to get how much time in official working time peroid and how much time in non official working time peroid for each person?
please help,Thanks
Annie Gao
Hi,
There is no “hour” level in eazyBI Time dimension hierarchies, therefore, you would need to convert your input data into timestamp or datetime format, otherwise 9:00 is just string and then you would need additional column which will be imported as measures in eazyBI (rule is to import at least 1 measure in the cube).
Also, it would be great if you can share more details about the use-case.
What kind of data source is that? How data is being updated? Does each user have one row each day?
Martins / eazyBI team
Hi martins，
Thanks for replying, I have resolved it with Sql since it imported with sql, thanks a lot