Agregate Drilldown Parameters With Multiple Drilldowns

  • 1
  • Question
  • Updated 2 years ago
So I asked this 2 weeks ago but then said forget it but it's come up again. Fundamentally just not understanding what parameters are passed on a 2nd drilldown for aggregate chart. Seen some related references on this subject but something I'm missing.

I have 2 aggregate models, lets say Accounts and Contacts. I have 2 Accounts charts that drilldown fine. From the 2nd chart I want to pass the drilldown context to the Contacts chart, which is on the Contacts aggregate model. Not seeing how to do that.

Ex/ So my 2nd chart is showing all Accounts in East that are Inactive. When I click chart slice I want that context to go to Contacts so I see all Contacts in those same Accounts.

I saw some references to the Highcharts API stuff, which is foreign, but even with that I don't get how you'd use that merge syntax, if that's what's needed, in the drilldown options...or am I supposed to be using a filter condition instead? If so, still confused how to pass the correct context.
Photo of ddeveaux

ddeveaux

  • 1,202 Points 1k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Peter Kong

Peter Kong, Employee

  • 440 Points 250 badge 2x thumb
Hi ddeveaux,

The Highcharts API shouldn't be necessary here - for each Series in a Chart Component, you should be able to control what chart is opened on the Drilldown and set a Field for the context: 



Let me know if this is what you're looking for or not!

Regards,
Peter
Photo of Peter Kong

Peter Kong, Employee

  • 440 Points 250 badge 2x thumb
I see what you are saying now, thanks for clarifying! I tried replicating your use case and am struggling to get this to work myself at the moment with the step you are at. I'd think that setting Account.Id = Id would work, I just tried it and it's not.

As you've said yourself, setting a filterable condition and querying the Model would definitely work as an alternative (assuming no other Component is using that same Contacts Model). With regards to passing Context cross-Model through the Series tab, I'll investigate it further and get back to you when I can validate some more facts (probably by tomorrow)! 

Thanks,
Peter
Photo of ddeveaux

ddeveaux

  • 1,202 Points 1k badge 2x thumb
But even with the filterable condition I'm not clear how the aggregate info gets passed. I understand we have to use alias names but still do not understand that in the context of drill downs.
Photo of Peter Kong

Peter Kong, Employee

  • 440 Points 250 badge 2x thumb
Assuming we are entering Merge Syntax in the Chart's On-Click Actions, it'd be {{rows.0.ALIASNAME}}.

So for example, {{rows.0.name}} if the alias is "name". The "rows" part is what accesses the context row. 
Photo of Peter Kong

Peter Kong, Employee

  • 440 Points 250 badge 2x thumb
Hi ddeveaux,

After discussing with the team yesterday, it seems that passing the {{rows.0.ALIASNAME}} through conditions would be the most straightforward way to transfer Aggregate Model values across Multi-Model Drilldowns. 

Thanks,
Peter
Photo of ddeveaux

ddeveaux

  • 1,202 Points 1k badge 2x thumb
Thanks for following up and I'll post back when able to try this in day or two.