Dates on Scatter Plot Axis?

Question

It doesn't look it is possible to put anything except measures on scatter plot axis.  It would be really helpful to be able to put date values on the scatter plot axis and then put dates in the play axis giving the user the ablity to watch a trend move through time.

Answer 1

I tried to reproduce the issue, but I think I'm missing something in the steps.  It seems to work fine for me to put non-measures into the playaxis field well drop zone, such as string values, integers (which are not marked as measures in the model), or date values.

Thanks,
Robert

---

Robert Bruckner   http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

I'm sorry I was unclear...

 

I'm trying to put the date in the X Axis AND the play axis field.  It is the axis box that won't work.

Answer 3

The scatter chart groups by the Details field (it creates one circle or bubble for each distinct value of the Details field) and aggregates the values of the horizontal and vertical axis fields, so those are measure axes.

---

Program Manager, SQL Server Reporting Services