When developing dashboards, there will always come a time when you are totally stumped on why something is not working correctly. Refer to spreadsheet debugger.xlf
to follow the example.
In our example, we will illustrate a simple bug and how to find its cause. Our example contains a drop-down control that populates a chart with preloaded data.
We've purposely populated the data area incorrectly ahead of time where we've accidentally forgotten to map an extra column on the row output. In reality, we won't know that the data has been incorrectly populated.
As you can see, using the Spreadsheet Table component is very helpful in seeing what is happening under the hood. In this example, you can easily oversee a large area of data. If we were to try to debug by figuring out which component is causing the issue, it would take much longer as we would have to go through the Dropdown component, Chart component, and Data Connection in order to find the culprit. This is a simple example, but just imagine if there were a lot more components involved.