Published on InterSystems Developer Community (https://community.intersystems.com)

Home > DeepSee Pivot tables group by week date display

Question
Benjamin Pickett · Apr 16, 2021

DeepSee Pivot tables group by week date display

When creating pivots in DeepSee, there is the ability to group date dimensions by Day, Week, Month, Quarter, Year.  For some of our reporting the Week option is desired.  However the display looks like the image shown below.  Notice the "YYYYW##" formatting.

Is there any ability within DeepSee to modify the display of grouped week dates?  E.g. instead of 2020W14 it could be 03/30/2020-04/05-2020, or even just the start or end date, etc.

#Analytics #InterSystems IRIS BI (DeepSee)
Product version: Caché 2015.1
$ZV: 2015.2.3 (Build 855_0_18038)

Source URL:https://community.intersystems.com/post/deepsee-pivot-tables-group-week-date-display