Product Feedback Forum
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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.

2 Comments

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.

Status changed to: Needs Votes & Comments

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