How do we display original date time in the X-axis in a stacked line chart? The group is per day, and data point is per hour. When we insert a chart the X-axis only shows 0-23 by default. What would be the steps to take so we will have yyyy-mm-dd hh instead of hh only.

In Data tab we selected "For each record".

Thanks,

Hi Rahul,

I found the solution.

The field used as a group contains Oracle date. The "stacked line chart" should use "On Change of" a formula which is whatever we desire to be displayed on the X-axis.  This formula is coded against this Oracle date field.

Sorry, I do not have time to post sample data but this is what we need to get this result.

Thanks,