Unable to Format Line Chart Continuous X-Axis DateTime as Date

[Dylan Sawyer-Villers]

See attached DXP for example.

I'm using Tibco Spotfire Analyst Version 7.10.

I've want to create a simple line chart that has X-Axis (continuous date binned) and Y-Axis (Cumulative Sum of values colored by 3rd field).

Date is formatted correctly in the Column properties.

The line chart refuses to change the X-axis formatfrom anything but [MM/DD/YYYY HH:MM:SS AM/PM] (12/31/2018 12:00:00 AM)

* This is true even when I autobin the values into month & year format.

* If I don't bin the X-Axis (consumer desired functionality is to bin by Day/Month/year), then the CumSum fails because it can't find Axis-X

[Gaia Paolini]

Hi surrounding the custom expression for X in angle brackets makes it look more acceptable:

 

although you lose the ability to add the vertical lines, as the axis is now categorical. Gaia

[Dylan Sawyer-Villers]

I require a continuous axis for the vertical lines.  I've played with a lot of different variations to try to format the axis - I'm trying to make sure I'm not overlooking basic functionality (the inability for properly format a Date axis on a visualization seems like an oversight by Tibco).

[Gaia Paolini]

Hi

Try this:

On the X axis: use just [Date] as a whole

On the Y axis:

Sum([Value]) OVER (AllPrevious([Date]))

I don't understand the construct Sum then Sum, it looks like the results are the same if you remove it.

Gaia

[Dylan Sawyer-Villers]

Gaia - I appreciate you help, but no luck.  Perhaps I'm missing something  Can you opent he DXP I uploaded and see if there's something obvious  

 

The formula: Sum([Value]) THEN Sum([Value]) OVER (AllPrevious([Axis.X]))

 

....Is literally the default from the "Cumulative Sum" Aggregration method on the y-axis.  This is the documentation I'm following:

 

https://docs.tibco.com/pub/spotfire/7.0.1/doc/html/ncfe/ncfe_using_expressions_on_aggregated_data_the_then_keyword.htm

[Gaia Paolini]

Hi

 

I see.  It was a bit confusing as [Value] is the name of the actual column as well as of the temporary result. The only way I can make your chart work without the time portion is without the THEN construct and with [Date] as X axis. Does that solution not work for you 

 

Gaia

[Dylan Sawyer-Villers]

Sorry - [value] is a terrible column name.  Apologies.

 

Unfortunately, I cannot use [Date] on the X-Axis because my consumers require the ability to aggregrate by Year>>Month>>Day.

 

I know I can do this with some complicated calculated columns and a property control; it just seems strange that Spotfire won't permit formatting of a Date axis.

[Gaia Paolini]

Hi - isn't a date without a time portion by definition aggregated by day Unless your real dates have a time element, the results look identical to me.

 

Gaia

[Dylan Sawyer-Villers]

I uploaded a screenshot of the specific problem - Are you able to format the DXP file I uploaded to to have a continuous axis without the "12:00:00 AM" formatting