Hi Team, Im trying to calculate the growth of our server volumes. My data is sorted as follows
| HOSTNAME |
DATE |
VOLUME NAME |
SpaceUsed |
| SERVER1-DB |
Nov 15, 2024 |
X: |
119 |
| SERVER1-DB |
Nov 17, 2024 |
X: |
122 |
| SERVER1-DB |
Nov 18, 2024 |
X: |
129 |
| SERVER1-DB |
Nov 24, 2024 |
X: |
160 |
| SERVER1-DB |
Nov 26, 2024 |
X: |
177 |
| SERVER1-DB |
Nov 26, 2024 |
X: |
178 |
| SERVER1-DB |
Dec 1, 2024 |
X: |
219 |
| SERVER2-DB |
Nov 15, 2024 |
Z: |
80 |
| SERVER2-DB |
Nov 17, 2024 |
Z: |
80 |
| SERVER2-DB |
Nov 18, 2024 |
Z: |
80 |
| SERVER2-DB |
Nov 24, 2024 |
Z: |
96 |
| SERVER2-DB |
Nov 26, 2024 |
Z: |
111 |
| SERVER2-DB |
Dec 1, 2024 |
Z: |
120 |
The output I want is
| HOSTNAME |
DATE |
VOLUME NAME |
SpaceUsed |
Growth over time |
| SERVER1-DB |
Dec 1, 2024 |
X |
219 |
86% |
| SERVER2-DB |
Dec 1, 2024 |
Z: |
120 |
50% |
Is this possible in quicksight ?
Hi @richardjansen23
It is possible using calculated fields and the following approach
Regards,
Giri
Hi @richardjansen23
Welcome to the Quick Sight community!
Please try the following calculated fields to get the desired output.
Example:
**LatestDate** - maxOver(DATE, [HOSTNAME, {VOLUME NAME}], PRE_FILTER)
**LatestSpace** - maxOver(SpaceUsed, [HOSTNAME, {VOLUME NAME}], PRE_FILTER)
**Growth**
(maxOver(SpaceUsed, [HOSTNAME, {VOLUME NAME}], PRE_FILTER) - minOver(SpaceUsed, [HOSTNAME, {VOLUME NAME}], PRE_FILTER))
/ minOver(SpaceUsed, [HOSTNAME, {VOLUME NAME}], PRE_FILTER)
Please refer to the below documentation this might be helpful for you.
Hope this helps!
Thanks @Xclipse thats been a great help. Thanks also to @Giridhar.Prabhu .
