No the activity date is one of my dimensions. The exta_time_next_date is a calculated time field.
for example I have on ACTIVITY_DATE = 28 March three EXTRA_TIME_NEXT_DATE fields that are:
- 05:15 hours
- 06:30 hours
- 01:30 hours
Total = 13:15 hours
For example i want a bar chart with ACTIVITY_DATE as a dimension, where i calculate for each ACTIVITY_DATE the total EXTRA_TIME_NEXT_DATE of the day before the displayed date.
Eventually i want to combine this formula with a formula that sums up another calculated field on the current date, so i cannot make changes in the dimensions.