Source Sheet for Dashboard Extension

If you are using the PowerKPIs dashboard extension, you need to create a source sheet first.

For Grid Layouts:

1. Create a worksheet with the data you would like to add to the PowerKPIs.

2. Add Measure Names to Details.

3. Add Measure Values to Details.

4. Add a Date field to Details.

5. Optional: Add a KPI dimension to Details.

6. Add the worksheet to this dashboard

For Tree Layouts:

1. Create a worksheet with the data you would like to add to the PowerKPIs.

2. Add Measure Names to Details.

3. Add Measure Values to Details.

4. Add a Date field to Details.

5. For Recursive data (parent-child) add a KPI and Parent KPI field to Details.

6. For Hierarchical data add the hierarchy in the correct order to Details.

7. Add the worksheet to this dashboard

Make sure to add only that level of detail to the source sheet, that is also needed for your KPI cards.