drill from aggregate model to basic model

  • 1
  • Question
  • Updated 3 years ago
  • Answered
I need to be able to re-create the pivot table feature of double clicking into a number to view the detailed data behind it.  

I can create the chart with the data (love it) but I want to allow the ability to click on the Column to see the Accounts that were aggregated to create the chart.  There are 2 models:
  • StateAgg - aggregate model of Accounts grouped by State
  • AccountList - Basic model - not loaded on page load
When I click on a chart from the StateAgg model, I want a pop up to show the Account Names that made up that bar.  There are 72k accounts so I can't have the aggregate group by Account Name.

Ideas?
Photo of Joe Ort

Joe Ort

  • 2,256 Points 2k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Just a shot in the dark here...

You should be able to access the State of the column that was clicked on through {{$Chart.category}} (or maybe {{$Chart.series.name}} ?), and in your action sequence as a result of the click pass that to a condition on your AccountList model, query, show popup.
This may help: https://community.skuidify.com/skuid/topics/-chart
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Yes.  Matt is right.