Pivot Table Date and Time

[Jetx227]

Hi All!
So a few weeks ago I had set up a pivot table based on some sample data that was stored in a table. The data table column headers are Date/Time (Formatted mm/dd/yy hh:mm AM/PM) and then 2 columns of temperatures. When I created the pivot table, I placed the data/time column into the "rows" field, and the temperature data into the values field (as averages). When I did this, it let me expand the rows field from dates all the way to minute. Note: I did this sample data test with only 2 days worth of data. Now I am trying to set up the same table (so I can make a graph from it) and I want the same option. But it only lets me expand the rows (date/time) to the date, and not to the hour or minute. Is this because I am working with a lot of data points compared to my sample set (sample set only had like 200 and this full set has about 13,000)? Is there a way to override this or would I more or less have to split the data up so I can view the hours/minutes? Please see the attached pictures for reference. The first is the sample data which has the rows field expanded as I explained. The second is the full set that only lets me expand to the data. Thanks for your help!

Sample Set:

Full Set:

 

[GraH]

Hi Jetx227,

I doubt it has anything to do with the number of records. I've made a quick sample of a bit over 1 Mio rows (I use EU settings).
Can you check the grouping settings. Right click in the dimension and in the context menu select grouping then highlight all the date/time details you need.

Cheers,
G.

 

[Anthony47]

In addition to GraH's suggestione (see above)

I would suggest that you create an additional column, calculated with the following formula:

=TEXT(A2,"yyyy-mm-dd_hh:mm")

(adapt to your local setting)
This will look like this: 2020-02-23 5:31

Now create the pivottable using, for the Row field, this new column

Bye