Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that displays only the max values from a data set and I would like to display the total of those max values in a digital gauage. However the digital display will sum all data points for the first line item in the table, or it will display only the max value and not sum the other values in the vertical column.
Any ideas as I am new to this?
Obviously this would adjust once items are selected or deslected.
Small subset of data:
group_name | Only (group_power) | Only (group_temp) |
B01 | 1896 | 90.05 |
B02 | 5031 | 90.95 |
B03 | 3337 | 90.05 |
B04 | 3372 | 93.65 |
B05 | 3968 | 85.55 |
B06 | 2579 | 90.5 |
B07 | 4121 | 90.95 |
B08 | 1848 | 94.1 |
B09 | 4848 | 97.7 |
B10 | 5182 | 98.15 |
B11 | 6106 | 102.2 |
B12 | 5509 | 97.25 |
B13 | 4966 | 102.2 |
B14 | 5652 | 92.75 |
58415 |
If you wan the aggrgation in the gauge, include the corresponding function in the expression.
An example: sum(aggr(max(Group_Power),Group_Name))
--Arun
Thank you for the reply. However when I use the example above it does not display a value other than 0 (zero).
Any other ideas?
let me take back the previous comment. It does display a value but it does not calculate the total values of the selected, it only display the first selected value.
Zero even if you select a/multiple groups? I have a similar example which is working fine:
sum(aggr(max(Group),Cost)) where bothe Group and Cost are dimensions/fields.
--Arun
Thank you... I got it now.
I did not have both defined as dimensions.
Your help is greatly appreciated.