Hi Team.

I have requirement where need to fetch data by metric for monthly basis.

And i have data for every day of month.

Now to design a metric in which it will fetch data for 1st day of every month in given interval.

Like if my metric as follows

{

“id”: “EmployeeInOutCntDay”,

“name”: “EmployeeInOutCntDay”,

“path”: “employee”,

“srcType”: “Company”,

“expression”: “sum(sum(normalized.data.employeeInOutCnt01Day))”,

}

And my eval metric as follows

c3Viz(Company.evalMetrics({ids: [“1234”],expressions: [“EmployeeInOutCntDay”], start: “2019-02-01T00:00:00.000”,end: “2019-04-20T00:00:00.000”, interval: “MONTH” }))

It gives me same value for all months.

Please help me to define expression so values return will be 1st day of month from type Employee and field name as employeeInOutCnt01Day

Thanks

Prashant Mahale