Flexible table component / Pivot Table

Hi @chunyau ,

Just trying to get this working. Am I right in thinking that you are doing this in a 'custom component', not in the new HTML component ? I've edited your code to make it specific to my data structures / query but I can't work out what to put in the 'model' section of the in order to make the data available to the HTML. Could you share your exact syntax? I tried using

{{query1.data}}

which does return an object, but that doesn't seem to work, I get, 'An error occurred rendering the PivotTable UI.'

Any help appreciated! Thanks.