Bar Chart Timestamp as Dimension

[megan_deboer]

Hi:

I am using an excel spreadsheet to load my data and have the employee activity with the timestamp. Is there a way to display the timestamp within a drill down? I'm not able to determine how to display the time in the field. When I'm loading the data in the data manager it is identifying it as a timestamp.  Would like to show the activity by day plotted by time within the bar graph. 

I appreciate the help! 

Megan

[Lisa_P]

You can create a Master Dimension to drill down from Date to Time if this is what you are trying to do.

[megan_deboer]

Hi Lisa:

Yes, that sounds great. Currently, my dimension options for the date is the original field and the auto calendar. Any idea what I would put for the time stamp to display?

Thank you! Megan

[Lisa_P]

You can reset your date field to have no time factor as the first dimension in your drill down:

Floor(date)

And then derive the timestamp from the original date for the second dimension

Timestamp(date, 'hh:mm')