Truncate date in dimension field in dashboard bundle sheets.

[Marcushenriquesk]

Hello, Attached are two images of my issue. You can see in the bar graph I am trying to create the dimension field for each bar is in MM/dd/yyyy hh24:mi:ss TT, Although I can truncate the dates using 'timestamp('Field_name', 'MM/DD/yyyy')'  the data doesn't reflect that and seems more like a label change. I want to be able to show the count of 'ACC_ID' per day .

[MayilVahanan]

HI

Try like below in script and use in front end

Date(Floor(Field_name), 'MM/DD/yyyy') as DateField

[Marcushenriquesk]

Thank you! this worked.