Crystal Xcelsius Help Needed

[Shantha]

Hi,

I am new to BO & Analytics tools, and having problem in displaying the dates in sorted order in the dashboard.

The dashboard is a trend chart, which picks up data from an QUAS query. The QUAS query has an BO universe object with timestamp column in it formatted to display as DD-MON.

while sorting the timestamp column in BO universe itself it is not displaying in sorted order.

For Example:

The date is being displayed after sorting in BO as

02-MAR
24-FEB
25-FEB
26-FEB
27-FEB

instead of

24-FEB
25-FEB
26-FEB
27-FEB
02-MAR

Please let me know if you require any additional information.

Thanks,
Shantha.



Talent is what you possess;
genius is what possesses you

 

[SkipVought]

Thats because you probably are using a STRING rather than a DATE data type; consequently 02-MAR colates before 24-FEB.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]