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…

Hi @richardjansen23 Welcome to the QuickSight 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** …

Calculating and Consolidating growth result

Question & Answer

Giridhar.Prabhu December 4, 2024, 5:50am 2

Hi @richardjansen23

It is possible using calculated fields and the following approach

Regards,
Giri

1 Like

Topic		Replies	Views
Illustrate YoY Growth Rates and hide original values Question & Answer calculations , Business-Intelligence-Engineer	4	37	August 27, 2024
How to arrive & % Growth Question & Answer admin , quicksight	5	150	February 28, 2024
Calculating sum from a specific period of time Question & Answer analysis , formatting , level-aware , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	8	1179	February 14, 2024
Calculating growth per quarter Question & Answer how-to	2	542	January 24, 2023
Calculating MoM growth and Churn risk with varied filters Question & Answer analysis , filters , error , quicksight , visuals , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	9	380	January 17, 2024

Calculating and Consolidating growth result

Related topics