Select which day to indicate if week format is selected in date field
Since I am showing the expected closing balance of an account in this widget, showing the date of the end of the week (in this case it should be Friday) make more sense than showing the first day of the week.
Can I choose which date to show when the week form is chosen under the date format?
Or in better way, can I show the date period of that week?
-
Hey Teh,
I'm not sure if there is a build in way in Sisense but you can change the labels with javascript. See this example: https://support.sisense.com/hc/en-us/community/posts/360033579294-Modifying-X-Axis-Labels
In your case, look at the value for the dimension, cast to a date, add 6 days to get to the end of the week and print.
Hope this helps,
Nathan
Please sign in to leave a comment.
Comments
1 comment