Hi, I have a DB Input with three columns Name, Timestamp and PENDING. So there are a limited amount of names, and each name has a particular value for pending at a particular timestamp. NAME Time Stamp PENDING NAME 1 Tue Apr 3 21:25:54 2018 5 NAME 2 Tue Apr 3 21:25:26 2018 0 NAME 1 Tue Apr 3 21:23:04 2018 13 NAME 2 Tue Apr 3 21:21:20 2018 3 NAME 1 Tue Apr 3 21:17:14 2018 1 I want to create a dashboard with time slots of 5 minute each as the columns and NAME values as rows, but PENDING should be filled if it falls under that timestamp and name. The time slots will keep on updating in 5 minute intervals so will the value of PENDING as the cross section cell ( case of NAME and timestamp slot category) It should look like this 21:25 21:20 21:15 NAME1 5 13 1 NAME2 0 3 NA I have looked up on this already a lot of times but couldn't get an exact answer as of now, I hope you could understand my requirements here and help me out with this. ... View more