Absence Chart

[snowman]

Hi there,

I have a simple table of 2 fields: timestamp (time-date) and employee ID. The timecard system will mark a record when an employee checks the timecard system everyday when he comes to work.

How can I make a table or chart that shows the absence (or presence) dates of all employees for a month ?

Thanks

[docpuddu · Accepted solution]

Hi snowman,
to some extent this is an "heatmap scenario".

I found this article very helpful and I think the solution showed in it can be adaped to your case as well.

https://qlikfreak.wordpress.com/2014/03/09/heat-map/

HTH.

Ciao,
/Andrea

[snowman]

Thank you, Docpuddu. It is more than what I need, and a nice article indeed.

One more thing I need to add, of which I searched from the community, is that my timestamp even though Load as Date, the Date gives multiple records for the same date, and I need to use this script expression to Load the Date:

Load Date(Floor(Date(timestamp))) AS Date

I wonder if simply use: Load Date(timestamp) AS Date

the system will still keep the time portion of the timestamp in the Date field and show multiple records for the same date ??

[docpuddu]

Hi Snowman, briefly...

- Date(timestamp) cuts the time part so Date(18/11/2019 09:56)  -> 18/11/2019

- Wrapping Date(timestamp) with Date(Floor( ... ))  doesn't change the Date behaviour

not sure, I've answered... HTH anyway.

Ciao,
/Andrea