Hi everyone!

REQUIREMENT:  My scenario is that i have datetime field in CRM & I am required to create a matrix report (using FetchXml) based on that datetime field such that DATE should grow horizontally & time should grow vertically & the matrix/data cell will be based on another attribute which will show the unique count.

So because in FetchXml we don't have time/hour clause to groupby so how can i achieved that!?

Can anybody give me an example of Javascript in Fetchxml to extract or split the date & time part separately !?

Much Appreciated!