Agregate Drilldown Parameters With Multiple Drilldowns

  • 1
  • Question
  • Updated 3 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,212 Points 1k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Peter Kong

Peter Kong, Employee

  • 596 Points 500 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 ddeveaux

ddeveaux

  • 1,212 Points 1k badge 2x thumb
Thanks but not really. I understand this part for the first drilldown (i.e. Chart of All Accounts drilled down to Accounts in East which is example you show.)

What I'm not understanding is now I'm on Chart 2, Accounts in East and the Axis is Account Status (Active, Inactive). So 2 bars on chart:

Accounts East = Active
Accouns East = Inactive

I now want to add a 3rd chart on the Contacts Aggregate model for a drilldown that passes these values in so I now see a chart of all Contacts that are in Account East = Active. Id = Id is not correct in this case since different model.
Photo of Peter Kong

Peter Kong, Employee

  • 596 Points 500 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,212 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

  • 596 Points 500 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

  • 596 Points 500 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,212 Points 1k badge 2x thumb
Thanks for following up and I'll post back when able to try this in day or two.