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 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** …

Hi @richardjansen23 It is possible using calculated fields and the following approach [image] Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc) Articles How do I do this year’s week N vs. last year’s week N for the last 5 wee…

Thanks @Xclipse thats been a great help. Thanks also to @Giridhar.Prabhu .

Calculating and Consolidating growth result

Q&A

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

Hi @richardjansen23

It is possible using calculated fields and the following approach

Regards,
Giri

Topic		Replies	Views
Calculating sum from a specific period of time Q&A analysis , formatting , quick-sight , level-aware , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	8	1281	February 14, 2024
How to arrive & % Growth Q&A admin , quick-sight	5	173	February 28, 2024
Illustrate YoY Growth Rates and hide original values Q&A quick-sight , calculations , Business-Intelligence-Engineer	3	93	August 27, 2024
PeriodOverPeriodComparison - Desenvolvimento QuickSight Q&A analysis , error , quick-sight , dashboard , calculations , Business-Intelligence-Engineer	2	42	November 19, 2025
Calculating growth per quarter Q&A quick-sight	2	576	January 24, 2023

Calculating and Consolidating growth result

Related topics