I am working on a requirement to create a transaction search report.
The report will need to use a drill to functionality; where the user can search for a particular transaction and be able to view the receipt details upon clicking/selecting a particular ‘Receipt No’(dimension)
The data source is a single table created using BigQuery.
Report 1: Click the receipt No and be able to view Report 2( Receipt Details)
However, the requirement is to have a transposed view of the receipt details(report 2 above)
Example from Tableau:
I am looking to replicate similar layout and UI in Looker and seeking advice.
I am trying to create a ‘drill to’ using custom html. But, need help to transpose the layout.
Thanks in advance.