Setting up your datasheet

For best practice and to get the best performance on your dashboard, we recommend dropping the measure(s) and dimensions on to the detail of your marks card on a separate/new worksheet. This will give DrillDownTree the best performance and flexibility for dashboard actions. See the image below for an example of how to set up your datasheet to feed the extension. All dimensions available on the datasheet can be used in the users Drill Down path. For tips and advice check out our BLOG.

The datasheet needs to be on the dashboard. It is not the most pretty visualization so it is best to hide it for your dashboard users on the dashboard. To do so: Add the worksheet to your dashboard as a ‘floating’ container. Then edit the size to 1x1px (and the position also to the 1,1 x,y position). This will make your datasheet active on your dashboard without being shown.