Allow minimum and maximum aggregation for date fields

[cnovus]

Currently, when adding a date field as a value in a pivot table, the only option is the # of years/# of days/etc. We need the option to add a minimum and/or maximum date for the selected rows.

The current 'work around' for this is to create an integer date, and then use a script to format the integer to present as a date. However, when exporting the data, the date shows as the integer value in the exported data, which is an unacceptable result.

Adding the date as a row value solves the export issue, but displays all date values for the lowest level of detail in the data source, which is also an unacceptable result.

If it was possible to add the minimum or maximum of a date field as a value in the pivot tables, this would solve all of the issues we currently have.

[brandon_ni]

It continually amazes me that we have to resort to workaround methods for performing simple minimum or maximum date operations, particularly given how this can be seamlessly handled in platforms like Tableau and Power BI.

[YuliyaMotiyets]

Hello @cnovus ,

Thank you for sharing your idea in the Sisense Community. We value your input and think this is a great idea! 

In order to prioritize our development efforts, we want to gauge community interest. We kindly request you to encourage other users to vote and comment on your suggestion. The more engagement your request receives, the higher the likelihood it has of being considered for implementation.

We appreciate your efforts!

Best, 

Yuliya

[yklam28]

We would like to be able to use the Max() and Min() function on date so we can easily get the earliest or most recent date.

[zach_myt]

This seems like a pretty standard feature and would be a really nice addition.

[Oleksandr_K]

 Hi,

Thanks for sharing your feedback and submitting this idea. This is vital for us.

We have this request in the backlog, but unfortunately, it is not prioritized for the short-term plans.  I will keep you updated on the progress.

[dougnewton]

Yes!

In both a row/pivot column, as well as a measure.

[zach_myt]

@Oleksandr_K Is there a work around you recommend until this feature becomes available?

[zach_myt]

One work around I am using is getting the minimum amount of days between now and the date I want to get the maximum of. Happy to hear of any others or if this formula could be turned back into a date somehow. The AddDays() function from the query build doesn't seem to be available in the widget functions.

MIN(DDiff(NOW(), [Days in date_field]))

[DRay]

Hello everyone,

I have asked for an update on if/when this will be implemented. I will follow up as soon as I have an update.

[DRay]

Hello @yklam28,.

Thank you for submitting your idea!

I have submitted this Idea to the product team and I will post updates here as they are available.

One of the ways we prioritize development efforts is by community interest. Please encourage other users to vote and comment on your suggestion, the more engagement a request receives, the higher the likelihood of it being considered for implementation.

Thank you for being a valuable part of our community!