More variety of date aggregations (Day of Week, Day of Month, Min/Max Date, Hour of Day, etc)

Feature Suggestions
1

Currently when presenting aggregation options for dates, there are many aggregations that are missing, e.g:

  • Min Date
  • Max Date
  • Day of Week
  • Day of Month
  • Month of Year
  • Hour of Day
  • Minute of Hour
2

Hi @Alex_H,
Thanks for your suggestion. I think these options are critical to bring more powers to the date function in Holistics.
I will add these to backlog for future improvement.

1 Like
3

I’d like to add (iso)week number of year to the list as well. Right now the weekly aggregation doesn’t really make sense when doing YoY comparisons, since week numbers do not match.

1 Like
4

Hi Khai - any news on this - surely it’s just a case of assigning particular existing SQL functions to each one? I am working around obviously but it’s not very neat.

5

Hi @Alex_H
Our team has already been researching and designing the functions for date aggregation.
But it would take time for us to implement and QA/QC to ensure the parity for all the databases we supported.
Thus, I cannot promise you the exact timeline when it will be released, but I want to ensure with you that it’s on our radar and I will let you know when there is an update on our side :smile: