Toggle between JSON sources within same page

[jatpola]

I have three brands (A, B and C). For each one of them, I have a different API query which gets me a JSON file with a bunch of brand data (the API calls are the same, with one of the parameters being brand ID thus varying)

I have a report with visualizations which could be used to display information for any brand.

Currently I have three pages with exactly the same visualizations, one for each brand. This makes it annoying to modify the report (each change has to be replicated thrice). I'd like to have a single page, and be able to filter by brand to choose what to show. 

I guess I need a custom table which combines data from the three JSONs. But the data I get from each JSON is not one-dimensional (for example, each brand has a table with customers on the rows and customer data on the columns).

Is there some way to toggle between brands, that is, to easily select which of the three JSONs I want to exctract data from?

Thanks a lot

[PhilipTreacy · Accepted solution]

Hi @jatpola 

When you combine the 3 JSON queries into a single table add a column that identifies which rows belong to which query.  You can use that column to switch between data in your report.

Please supply some sample data from each query.

Thanks

Phil