Forum Discussion
lafakios
Helper I
Helper IHow to add dynamic rows with an average value based on a group of rows
Hi, I would like to create a visual like the following one. WANTED VISUAL Not To Be Shown HigherOrLowerThanAverage ItemA 1.4 Average of the last 3 ItemA I...
lafakiosHelper I
Helper IThe itemA 1.4 data were missing in the sample table.
Please find below the updated sample table including itemA 1.4
| Item_ID | param_id | value |
| ItemA 1.4 | Param1 | 0 |
| ItemA 1.4 | Param2 | 9 |
| ItemA 1.4 | Param3 | 1 |
| ItemA 1.4 | Param4 | 6 |
| ItemA 1.4 | Param5 | 30 |
| ItemA 1.3 | Param1 | 1 |
| ItemA 1.3 | Param2 | 12 |
| ItemA 1.3 | Param3 | 2 |
| ItemA 1.3 | Param4 | 3 |
| ItemA 1.3 | Param5 | 20 |
| ItemA 1.2 | Param1 | 2 |
| ItemA 1.2 | Param2 | 14 |
| ItemA 1.2 | Param3 | 6 |
| ItemA 1.2 | Param4 | 3 |
| ItemA 1.2 | Param5 | 10 |
| ItemA 1.1 | Param1 | 3 |
| ItemA 1.1 | Param2 | 16 |
| ItemA 1.1 | Param3 | 4 |
| ItemA 1.1 | Param4 | 4 |
| ItemA 1.1 | Param5 | 30 |
| ItemA 1.0 | Param1 | 5 |
| ItemA 1.0 | Param2 | 12 |
| ItemA 1.0 | Param3 | 7 |
| ItemA 1.0 | Param4 | 12 |
| ItemA 1.0 | Param5 | 14 |
| ItemB 1.3 | Param1 | 20 |
| ItemB 1.3 | Param2 | 2 |
| ItemB 1.3 | Param3 | 14 |
| ItemB 1.3 | Param4 | 6 |
| ItemB 1.3 | Param5 | 3 |
| ItemB 1.2 | Param1 | 2 |
| ItemB 1.2 | Param2 | 14 |
| ItemB 1.2 | Param3 | 6 |
| ItemB 1.2 | Param4 | 3 |
| ItemB 1.2 | Param5 | 10 |
| ItemB 1.1 | Param1 | 3 |
| ItemB 1.1 | Param2 | 16 |
| ItemB 1.1 | Param3 | 4 |
| ItemB 1.1 | Param4 | 4 |
| ItemB 1.1 | Param5 | 30 |
| ItemB 1.0 | Param1 | 16 |
| ItemB 1.0 | Param2 | 4 |
| ItemB 1.0 | Param3 | 4 |
| ItemB 1.0 | Param4 | 30 |
| ItemB 1.0 | Param5 | 5 |
