Allow minimum and maximum aggregation for date fields
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.
Zach Williams
·1 year agoJust noting that this is the 6th most liked topic in the discussion and has more comments than the other 1-5 posts. Thanks for following up.
yigale
·1 year agozach_myt We recognize this was marked as planned, and we still believe this is a valid request. However, given the team priorities and capacity, this feature is currently not yet committed to be delivered, and therefore we have removed the planned tag, to avoid misleading that this is in the works.
More votes would be helpful to understand how it compares to the other higher voted items. Thank you for being engaged with the commurity!
Zach Williams
·1 year agoHi DRay,
This was marked as vital by Sisense team member in 2023, then status changed to planned on 8-21-2024, why is it being changed back to needs votes and comments today (3-5-25). Thanks!
DRay
·1 year agoThank you for submitting your idea!
I have brought this Idea to the product team and will post updates here as they are available.
One of the ways we prioritize development efforts is by community interest. I encourage other users to vote and comment on this suggestion. The more engagement an idea receives the higher the likelihood of it being considered for implementation.
Thank you for being a valuable part of our community!
yklam28
·2 years agoThe lack of this functionality has continued to block us from building a certain dashboard for our users, which has been frustrating. None of the work-around really works for us since we need to return the max or min of a certain date, and potentially use them in a formula.
rosenauj
·2 years agoThis is a really important feature for us. We have no viable workarounds and may need to resort to calculating the values and storing them every time the cubes build just to be able to display a date in a table.
yklam28
·2 years agoWe 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 Williams
·2 years agoThis seems like a pretty standard feature and would be a really nice addition.
Oleksandr_K
·2 years agoHi,
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
·2 years agoYes!
In both a row/pivot column, as well as a measure.
Zach Williams
·2 years agoOleksandr_K Is there a work around you recommend until this feature becomes available?
Zach Williams
·2 years agoOne 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
·2 years agoHello 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
·2 years agoHello 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!
DRay
·2 years agoThis has been discussed extensively by the product team, and there are no plans to include this in the roadmap at this time.
However, I am going to leave this post open to gather more votes and comments. Maybe we will see it included in a future release!
Yuliya Motiyets
·2 years agoHello 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
brandon_ni
·3 years agoIt 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.