The Source Table:
Insert any of the the Advanced Tables macros (Table Plus, CSV Table, Attachment Table, JSON Table) and combine it with our app.
You can find more information about the Advanced Tables app on the documentation site.
Pivot Table & Advanced Tables - JSON Table
3. Add the Pivot Table macro to the JSON Table macro with the filtered data.
Pivot Table allows you to summarize and aggregate your table data.
You can select the following operations: Sum, Count, Min, Max, Average, Literal.
Set the Date format which is used in your source table before aggregation by date.
Table Transformer & Advanced Tables - JSON Table
1. Add the Table Transformer macro to the JSON Table.
You can place one or multiple tables within the macro body to merge, look up them or to perform custom calculations.
This SQL query allows you to create a new column with the year outputted.
You can change the filtration criteria, the pivot table and chart parameters on the fly.
The changes will be automatically applied to the data from the JSON Table macro.
You can use the JSON Table macro with each of our macros separately or combine them according to your needs.