Hey all,
I got this data table with the fuel consumption of cars per minute https://imgur.com/7AhHQuu . It also includes which areas the cars have driven in and what they were doing.
I would like to summarize this data as consumption per unique car ID, instead of per minute. Then I want to use this summarized data to make visuals to further analyze the data. Like finding which car has the maximum consumption. I tried making an Aggregated Table using the Group By function like this https://imgur.com/55MlUcu .
This data is what I am looking for, however by using Grouped By I have lost some important data identifiers.
For example, I want to find the maximum total consumption per car. By putting it in a Table Visual and making a Card Visual with the maximum consumption I get this https://imgur.com/n3kDvUF . This looks fine, but the Table Visual is based on the original data, and the Card Visual is based on the Aggregated Table.
Now if I filter the page on the Area the cars have driven in the consumption of the table visual does correctly change, but for the Card Visual it does not https://imgur.com/0CaWyvV . Probably because this data is not a part anymore of the Aggregated Table (if I included it I would not get the consumption per car).
So, I want a table that summarizes my data per unique car ID, but at the same time I want the filters from my original table to still apply so I can further analyze and filter the data. How can I best approach this?
