Rolling Up A Date By Day Of The Week
Introduction
There is no OOTB option to roll up a date by the day of the week.Use this simple trick to achieve this with a simple custom field which will display and sort as a calendar day without any additional script.
Instructions
Create an expression field in the Elasticube > Give it any suitable name e.g. Day of Week.
Enter the formula as any day where the date corresponds to the day of the week.
E.g. Feb 01, 2016 is a Monday, Feb 02, 2016 is a Tuesday etc
Create a chart or a pivot in your dashboard, add the custom field with the day roll up and format the field to only show the day. e.g. EEE or EEEE
0 comments
