Help Using the TIPS/CPI Query
The TIPS/CPI Query has several features to make it easy for you to display and save data in different ways. The functionality provided is similar to features found in spreadsheet software.
The table displays the first 50 records starting with the most recent date and going backward. You can use the arrows in the lower right section of the table to move to additional pages of data, 50 records at a time.
If you move your cursor into the column label block, you'll find an arrow on the right. Click on that arrow and it will sort the records in ascending order or descending order, alternately. If the arrow is pointing up, the sort is ascending. If the arrow is pointing down, the sort is descending.
Filtering by Date
You can select a single date or a date range to display information for those dates. To select a single date, click on the calendar icon in the box below the column heading and double click on the date. (NOTE: If you double click too quickly, it may not register your choice). The calendar icon will close and then the date you chose will display in the box below the column heading.
If you want a range of dates, click on the calendar icon, single click on the first date and then with the calendar still open click on the second date. The calendar icon will close and the date range will display in the box below the column heading. Data for the selected date range will display in the table.
For larger date ranges you can zoom out to Year and Decade views by clicking the Calendar's title.
You can also select the "clear" link below the calendar to remove any filtering you have applied.
You can move between pages of the table by using the right and left arrow at the bottom of the table or by entering the page number in the block between the left and right arrows. You can also change the number of rows that display per page by selecting the arrow in the box next to "Show rows:" and select 100, 250, or 500. To the right of the "Show Rows:" box you can see what rows are available in the table out of the total number of records.
You can export the data from the table to these file formats:
- CSV - Comma Separated Values
- TSV - Tab Separated Values
- XML - Extensible Markup Language
Select the button above the table that has the appropriate acronym for the format you want to use. The File Download box will appear - chose open or save. If you choose save, you can use the standard "Save As" dialog box to save your file.
Note: When selecting CSV, truncation occurs due to the extended number of digits - Excel only handles up to 15 digits.