Drilldown Based on Query Results


I want to connect two dashboards via Drilldown (or a similar feature). I have been reading the docs regarding drilldown and did not find a way to do precisely what I want. So, I am hoping for someone with more experience :index_pointing_at_the_viewer: to have an idea :bulb: I could not have (do you think I should merge my indices?!).

The two dashboards I want to connect do not use the same index. They use different but related indices (I will use an example that is equivalent to my use case so that you do not need to understand the details of my organization). One dashboard presents data from an orders index. Another dashboard, from a payments index. Each order can have more than one payment.

orders documents have properties like id (id of the order), product_name, client_id, purchase_date, delivery_date, cost, payment_ids (it's an array), payment_amounts (it's an array).
payment documents have properties like id (id of the payment), order_id, date, payment_method, amount.

Here is what I would like to do. You are in the orders dashboard :bar_chart:, you have filtered the data down to some specific orders that you need to investigate (for example, orders for a specific product :package: in a specific period :spiral_calendar:) and you want to see the payments dashboard :chart_with_upwards_trend: for the payments of those orders. Since the filters are on product_name and on purchase_date, you cannot carry those filters over to the payments dashboard :chart_with_upwards_trend:. What I want to carry over is the list of payment_ids.

The opposite case is also possible: you are in the payments dashboard :chart_with_upwards_trend:, you have filtered it down to payments done with credit card :credit_card: after a certain date :date: (for example), and you want to see the orders dashboard of the related orders. I don't want to carry over the filters: orders don't know about credit card or payment date. All I want to see is the orders dashboard for a list of order_ids.

How can I do this? I don't want to copy filters. I want go to a dashboard with a specific list of document ids. I guess I could generate an URL if I know the ids, but how can I get data from the documents while generating a drilldown URL?

Thanks for reading my rather long post! :zipper_mouth_face:

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.