Post

3 followers Follow
1
Avatar

Different date format options in report charts and graphs

Currently in the charts and graphs, dates (specifically when grouping by weeks) show as something like 2015-W48 (for the 48th week of the year). It would be much more informative if you could choose to display the first or last date of the associated week instead. Typically, someone wouldn't know which week the 48th week is referring to but if it showed 11/23/2015 they would. Perhaps this is accomplished via an additional dropdown for choosing the date format when configuring the charts and graphs.

Thanks!!

Clint Bontempo Not planned

Official comment

Avatar

Clint,

There is currently a Change Request already in the pipeline for the date format to be configurable. There is currently no ETA on the availability of this functionality but the request ID is CR-259564

Boris Krutiy
Comment actions Permalink

Please sign in to leave a comment.

2 comments

0
Avatar

Hi, 

About this feature, is there any built in datetime formater function that we can use in report formulas ? 

In order to just show a Month name, I had to write this awesome code snippet in the formula are :D
I am not proud of sharing such a snippet but maybe it will be useful for some other Clarizen users.

If(Month($CreatedOn)=0,"January",
If(Month($CreatedOn)=1,"February",
If(Month($CreatedOn)=2,"March",
If(Month($CreatedOn)=3,"April",
If(Month($CreatedOn)=4,"May",
If(Month($CreatedOn)=5,"June",
If(Month($CreatedOn)=6,"July",
If(Month($CreatedOn)=7,"August",
If(Month($CreatedOn)=8,"September",
If(Month($CreatedOn)=9,"October",
If(Month($CreatedOn)=10,"November",
If(Month($CreatedOn)=11,"December","")
))))))))))) 

Mustafa Kipergil 0 votes
Comment actions Permalink