User-configurable options
Users should be able to summarize their metrics using the basic summary functions:
- Sum (default for numeric)
- Count
- Avg
- Min
- Max
- is this list complete?
Each metric should be displayed with a string label, for example "Sum: 1,234Kb/s", per the EUI examples.
There are several open product questions, input needed: cc @flash1293 @timductive @timroes
How to enable the summary row:
a. More flexible than visualize: Separate summary row and function for each metric (this is my preference)
b. Same functionality as visualize: Enable the summary row for all metrics together, only one function allowed for the summary
Number formatting:
a. Use the column number formatter unless we are taking the Count. Count uses the default number formatter. (simplest option, and my preference)
b. Allow a separate number formatter for the summary value
Edge cases in configuration
I believe there should be a separate summary for each transposed column, which will increase the complexity of the implementation. It requires client-side calculation instead of server-side.
The "Last value" metric has several edge cases. I recommend that we don't enable summary on the "last value" because it will cause more problems than benefits. The edge cases are:
- Array values: This is an existing bug in the Visualize data table. We can't summarize array values.
- Non-numeric values: The only metric we can support is Count or Unique count, which I am not sure benefits users
Question: Should we allow summary on last value, even with the known limitation?
User-configurable options
Users should be able to summarize their metrics using the basic summary functions:
Each metric should be displayed with a string label, for example "Sum: 1,234Kb/s", per the EUI examples.
There are several open product questions, input needed: cc @flash1293 @timductive @timroes
How to enable the summary row:
a. More flexible than visualize: Separate summary row and function for each metric (this is my preference)
b. Same functionality as visualize: Enable the summary row for all metrics together, only one function allowed for the summary
Number formatting:
a. Use the column number formatter unless we are taking the Count. Count uses the default number formatter. (simplest option, and my preference)
b. Allow a separate number formatter for the summary value
Edge cases in configuration
I believe there should be a separate summary for each transposed column, which will increase the complexity of the implementation. It requires client-side calculation instead of server-side.
The "Last value" metric has several edge cases. I recommend that we don't enable summary on the "last value" because it will cause more problems than benefits. The edge cases are:
Question: Should we allow summary on last value, even with the known limitation?