SiSense Analytics - Localization and DayOfWeek Correction

Comments

2 comments

  • Avatar
    Oxana Noa Umansky

    Thanks for sharing Santhosh! What Sisense version are you using? 

    0
    Comment actions Permalink
  • Avatar
    Santhosh Prabhakaran (Edited )

    Hi Oxana,

    I am using 6.6.1.11003.

    The following will help you get sortable days

    ifstring (length(ToString(GETDAY([TIMESTAMP])))=1, '0'+ToString(GETDAY([TIMESTAMP])), ToString(GETDAY([TIMESTAMP]))) + '. ' + DayName(DayOfWeek([TIMESTAMP]))
     
     
    I found it useful to use the following to get sortable time
     
    ifstring (length(tostring(gethour([TIMESTAMP])))=1, '0'+tostring(gethour([TIMESTAMP])), tostring(gethour([TIMESTAMP])))+':'+ifstring (length(tostring(getminute([TIMESTAMP])))=1, '0'+tostring(getminute([TIMESTAMP])), tostring(getminute([TIMESTAMP])))+':'+ifstring (length(tostring(getsecond([TIMESTAMP])))=1, '0'+tostring(getsecond([TIMESTAMP])), tostring(getsecond([TIMESTAMP])))
     
    Thanks,
    Santhosh

     

    0
    Comment actions Permalink

Please sign in to leave a comment.