Dec 10 2023 06:08 PM - edited Dec 11 2023 06:10 PM
How can i group this type of data in my pivot( weekly per hour )where dates and times are combinedined together in same cells in the raw data
When i try it says cannot group selection , its an extensive list,
say nov 12 to nov 18 should be in the same week and for week 1 . it should break it down to hourly 24 hours like in second screenshot, same for week 2 and 3
Dec 10 2023 06:53 PM
Dec 10 2023 09:39 PM
Dec 11 2023 07:14 AM
When i try it says cannot group selection , it's an extensive list
This error suggests one or both of the following is true:
1. Those dates are texts
2. There's non-dates mixed with the text
From the screen capture, my guess is it's #1.
Convert numbers stored as text to numbers - Microsoft Support
Dec 11 2023 09:08 AM
Dec 11 2023 10:58 AM