With the classical Reports & Dashboards module, it was possible to execute a simple query and to see a table that would give an overview of the selected parameter(s) in one table:
I'm trying to do the same thing with the new dashboards module. The closest I could get is to use the "Query" data and specify the items like shown in the screenshot:
Type "Table 3" shows the element id instead of the element name, other types like "State 3" shows a GUID.
-How can the element name be shown in the table? I tried to add "column manipulations" but that doesn't seem to show how to get to display the element name
-The classic report module had the option to select to add trending values (min/max/avg), is that also possible with the new dashboard data query? Or am I using the wrong component and is there an alternative available to easily have the same query functionality like the classic reporter has?
For this use case, the Pivot table would be more than enough. You can use the parameter feed and pass the parameters you need to the table.
You could, also, add avg, min, and max to the results. Showing the source element is also possible following this approach.
If needed, the time range component could be used to further filtering.
For trending, the line and area chart could be used and the same parameter and time period feeds may be used.
Note that most of the options above are also possible via GQI.