view: global_dashboard_poc { # Or, you could make this view a derived table, like this: derived_table: { sql: select * from test_table pivot(max(dimension_value) for LOOKER_COL IN ('CD_1', 'CD_2', 'CD_3'));;}}Is there any possible way where I can hav...

I have created an explore and based on the filters it provides output in the following format:Dim1 Dim2(String) StringValue 1 key1 val1 1 key2 val2 1 key3 val3 And we pivot this to the following format.dim1 key1 key2 key3 1 val1 val2 val3 Now, the nu...