Extensions are dashboard objects that operate on a dashboard level. They don’t directly connect with your databases but instead connect with a sheet containing the data you want to use in your dashboard. Let’s create a datasheet for your extension by following these steps:
- Open an empty workbook and connect it to your desired dataset.
- Create a sheet, choose any dimensions and measures, and drag and drop them in the ‘details’ section of the marks pane.
- Rename the sheet to ‘datasheet’ as this will be the data used in the Extension.
This approach efficiently offers your data to your dashboard, especially when dealing with large amounts of data, and enhances the overall dashboard performance.
TIP: Do you want to hide the datasheet that delivers the data to the Extension in your dashboard? Simply select the sheet in the dashboard, go to the layout options, make it float, and resize it to 1px by 1px!