How to show dates until current date in the xaxis of a line chart although data is available till Dec 2017

[Prateek Rawat 3]

Hi All,

I the below line chart for current filter selection the max date is Dec 2017 

y-axis expression  = UniqueCount(If([DATE.]<=DateTimeNow(),[Val])) OVER (AllPrevious([Axis.X]))

X-axis =  <BinByDateTime([DATE.],"Year.Quarter.Month",2)>

Requirement is to display date in x-axis until 30-JUN-2024 and the data points should also be generated until 30-JUN-2024, but the value should remain 73.

Is this possible to achieve in Spotfire?

[Olivier Keugue Tadaa]

Hi Prateek
Spotfire displays existing values on the x-axis.
Fortunately, Spotfires allows a combination of several data sources in a single report

To do this you need to have a data source with the dates needed for your chart

Then, you can either use the columns matches as shown below 👇

  

 

or combine the two tables into a single via the data canvas like this 👇

Note the "Right outer join" but the "full outer join" will also work

 

Then you create a filter to show only the date until today

e.g. filter current date.   :::::  [Date]<=DateTimeNow()

 

an example result below 👇

 

Find attached an example of both approaches 

data - missing dates.dxp

I hope this helps

 

Edited June 26 by Olivier Keugue Tadaa