Drill Down From Summary To Detail Records
I know how to use different tables on cards when drilling down. My question is around handling drill downs from a summary table on the first layer/card to a detail table when drilling down to a second layer.
The summary table holds KPI's such as # of created requests by month, # closed requests by month, # active request by month, delivery date attainment, etc. Each summary record was derived using multiple detail records and holds the detail record keys in comma delimited text field. My guess is there isn't an easy way of doing this but I'd like to create a card using the summary table but drill down into the detail table showing which detail records make up the summary record.
I know I could have built the card using the detail file, eliminating use of the summary table, and drill down would be easy, however, the summary table comes from another tool (ServiceNow) that we use to track our work and I need the Domo cards to match what users see in that tool (ServiceNow).