To replace some of the existing custom legacy reports with the new Dashboards we're looking for additional possibilities in the Dashboards. Is following possible?
We have a table with channels. The table includes columns for 'customer' and some measurement columns.
We need the possibility to filter on the 'customer' and to iterate through all entries for one of the measurements.
The report needs to show first a table with the channel name and one of the measurements in the second column.
Below this table trend graphs for that measurement for all channels are listed. All trend graphs should have same configurable (through feed) Y axis range, so that comparing graphs is intuitive. If y-axis has an automatic range it is not intuitive to read and compare the graphs.
Next to that also a time range selection is needed.
Following are the feeds:
- customer
- Y-axis min
- Y-axis max
- range (hour, day, week, month, year, yesterday)
Hi Jeroen,
Currently dashboards has a most of these features available:
- Customer selection: This can be achieved by creating a query that fetches all possible customers (from DOM or Ad hoc source). This query can display its results in a dropdown component. The dropdown selection can then be used as an input of a column filter on the measurement query. The measurements themselves can be displayed on the line chart component, which supports parameters or queries.
- Y-axis min/max: it is currently not possible to feed a value to the min/max config of the line chart component. If you want this feature, you could create a feature suggestion for it.
- Range config: Dashboards has a 'time range' component available that can be used to feed a time range or a 'to' & 'from' to other components/queries. The component can be configured with presets such as previous hour, last week, next 15 minutes, ...