Summery not in proper order
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Lately it seems all my reports are not summarized in order.
I have data that is by Fiscal Year and Month as a primary grouping in Summary tools. It comes out as follows -
Am I missing something? Since there is only one of each primary groupings, the subsequent groupings should not impact the order of this column (total number of jobs, outcomes, avg times, etc.)
FY / M (Approved) |
2022 / 03 |
2022 / 05 |
2023 / 07 |
2023 / 08 |
2022 / 04 |
2022 / 06 |
2022 / 12 |
2022 / 02 |
2022 / 09 |
2022 / 11 |
2022 / 07 |
2022 / 10 |
2022 / 01 |
2022 / 08 |
Solved! Go to Solution.
- Labels:
- Best Practices
- Help
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@tim_koirtyohann is this what you're after? Your [FY / M (Approved)] field isn't a recognised date format that can be sorted and so in this approach I parse that into a properly-formatted Alteryx date (yyyy-mm-dd), use that to sort, and then remove it to clean the data set back up. Obviously if you want the dates the other way round, just change from ascending to descending in the sort tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes I forgot about that tool. Thanks.