This article contains answers to the following questions:
- What do I do if the source data has been modified?
- 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?
What do I do if the source data has been modified?
When editing a data feed, you may see warning icons in your column headers and the following error message. This means changes have been made to the associated source data:
This message displays if any of the following have changed in the source data:
- Column name
- Column data format
- Column order
- Column deleted
Click on columns with warning icons and look under Column Properties to see more details.
If a column's name has changed:
- Confirm that the column is pointing to the data you want it to. You will see this message:
If a column's data format has changed:
- Click Apply new format. You will see this message:
If a column has been deleted or the column order has changed:
- Ensure your formulas are pointing to the expected spot in the source data. For example, if column CC in your source data has been deleted, you need to delete column CC in the data feed and ensure the columns that follow are properly aligned.
After making all necessary changes, click Save to dismiss the warning.
Note: If you’re using your data feed for a metric, any new formulas will be applied to the metric going forward, but the previously stored data will not be changed.
If any of your columns display error icons, this indicates that your data feed is unable to reference data from the source data.
This could be because:
- The source data was partially or entirely deleted.
- There’s an issue with the formula(s) used in your data feed.
Some columns aren’t displaying in the data feed. Why?
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).
What if the source data is in multiple sheets?
If your data feed is connected to a multi-sheet data source, for example, an Excel file or Google Sheet that has data in multiple sheets, you can access the data in the other sheets when editing the data feed.
Double-click a column in the raw data to select it. Use the Sheet drop-down menu to select the sheet you want to access. You can use the drop-down to switch between sheets when writing formulas and creating data feeds. (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.)