This article contains answers to the following questions:
- Some columns aren’t displaying in the data feed. Why?
- What if the source data is in multiple sheets?
- Why can’t I select my date column when creating a metric?
- How can I see more of my data?
Some columns aren’t displaying in the data feed. Why?
For files stored on OneDrive, SharePoint, Box, and Dropbox, after creating a data feed, you may notice that not all of your columns were automatically added.
For performance reasons, in the data feed editor, Klipfolio automatically adds only the first 30 columns of the source data. You can add remaining columns, maximum of 30 at a time, by clicking the Add all columns (located in the toolbar). If there are columns in the source data you don’t want to add to the data feed (for example, empty columns), you can add individual columns instead by clicking the Add column button (located in the toolbar).
For uploaded local files and Google Sheets, only the first 100 columns from your source data will be included in the data feed. We recommend using smaller data sets for your data feeds and metrics. If you need to create a data feed that includes > 100 columns, please contact our Support Team to discuss increasing your limit.
What if the source data is in multiple sheets?
For uploaded local files and Google Sheets, you choose a single sheet to work with when you create a data feed - one data feed per sheet. To create a data feed that includes data from more than one sheet, you can create single data feeds and then merge them. Learn how here.
For files stored on OneDrive, SharePoint, Box, and Dropbox, you can access the data in the other sheets when editing the data feed. To access the raw data and the sheet selector, double-click a column header in the data feed table. Then, use the Sheet drop-down menu to select the sheet you want to access. (See below.)
Why can’t I select a date column when creating a custom metric?
When creating a custom metric, you have the option to add date and time values by selecting a date column from your data feed. Make sure the column in your data feed that contains the date/time values is set to the Date data format so it can be selected when building custom metrics. Learn more about setting column data formats here.
How can I see more of my data?
If a data feed contains many rows of data, all rows may not display at once. To see additional rows or to go to the last few rows or first few rows, click one of the links that display below the data feed table. For example, “Showing 75 of 352 rows". "Show 100 more.” or "Go to the last few rows". (See below.)