Hey! Sorry if this is a n00b question… I’m just getting started with Dashboards and Reports.
Is it possible to generate a series of charts at runtime (multiple charts, not multiple series in one chart)? I can generate the data as two queries (Query A gives me a list of ID’s, Query B is run multiple times with the ID as a filter - one chart for each ID) or as a single query (IDs and series data in one query, but the results would then be separated into a chart per ID)?
A use case for this would be: We have 5000 stores. We want a dashboard or report that will show us a chart of the daily sales values for each of the top 20 stores by their most recent monthly total (a chart per store). Each month the set of stores would change, so we couldn’t use fixed criteria in 20 separate looks