Hi,
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 to have an idea 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 , you have filtered the data down to some specific orders that you need to investigate (for example, orders for a specific product in a specific period ) and you want to see the payments dashboard 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 . What I want to carry over is the list of payment_ids.
The opposite case is also possible: you are in the payments dashboard , you have filtered it down to payments done with credit card after a certain 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_id
s.
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!