Data Table: Dates
Version: 01
File Name: DatesV01.SBDF
(A Spotfire Binary Data File (SBDF) is a file format used for storing data within the Spotfire BI platform.)
Load the Data:
Download the data table file
Load the data into a Spotfire file
Launch a Spotfire file
Add a data source
File > Add Data
Navigate to the location of the downloaded data table file by using "Browse local file"
Select the example data "DatesV01.SBDF" file
Click Open
On the "Add data to analysis" screen, update the new data table name to be "Dates" and click OK
At this point, the example data has been loaded into the Spotfire file. Feel free to follow along with the video.
About the Data:
All data tables provided contain fabricated data. This example table contains a series of dates from 1/1/1900 through 12/31/2100. The columns with dates as integer numbers represent the way Excel stores serial numbers for dates. They start Jan 1, 1900 and increment up for each day after.
Stats:
Number of Columns: 7
Number of Rows: 73.4 K
Size on Disk: 938 KB
Column Details:
Name | DataType | Units |
---|---|---|
MonthFOM | Date | - |
MonthEOM | Date | - |
DateDaily | Date | - |
MonthFOMNumber | Integer | - |
MonthEOMNumber | Integer | - |
DateDailyNumber | Integer | - |