In this article, you will learn how to properly configure your Google Sheets datasource for Awesome Table work properly. You will learn the prescribed filters and parameters.
1 - First Row : the column headers
Use short descriptive name. The columns header will serve as filter title and chart headers.
2 - Second row : the data filters & parameters
Add a blank row below your header row (like the image above).
Note: Even if you don't use any filters, you must add the blank row.
Set your parameters and filters in the second row. The headers in the first row will be reused in the Awesome-Table view as titles for filters. Learn more about available filters and available keywords.If a cell contains 2 elements, separate those elements with a "-".
Do not hide the second row as this will prevent Awesome-Table to correctly use the appropriate filters and parameters.