I have data model that consist of only one large table.
This table has transaction_id, amount, name, merchant_name, etc...One row for each transaction.
I am trying to create a bar that will show max amount for each name, but I would like to be able when I click on the bar to see the all fields associated with that transaction in a separate table. (say straight table with all the fields)
I tried to use Name as Dimension and max(aggr(max(amount, Name)) as an Expression
but when I click on the bar it does not separate that one transaction_id in that straight table.
How can I accomplish this?