Date Sorts

[PeterV]

Hi,

Am I the only one that finds it frustrating that when you are summarising values by dates that all the natural sorting is lost.  A good example is using the DateTimeFormat function to strip out the days so that you can get monthly totals but this is then saved as a string so time-related ordering is then lost.  Is it possible to add the ability to summarise by time periods (weeks, months, quarters, etc....) and for the natural progression of time / days to be maintained as I am constantly having to reinvent the order.

In addition, it would be useful if we could extend this to provide time-based running totals so for example one tool could be configured to point at transaction data (date & value) and would automatically summise the Jan value and then monthly year to date value by period (selected as weekly, monthly, etc...) up to the max date value in the dataset.

Just a thought,

Peter

[David_W]

No you aren't the only one I share your pain.  Please share if you have found a resolution.

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!