Hi All, Trying to arrive % growth over previous week % achd, couldn’t able to get through . can any help me in getting the support. sample snapshot [image]

Hello, could you please elaborate the question more clearly? I don’t get what you want to achieve.

@Sophia , Thank you for your reply, actually I am trying to show % passed growth over previous week, so I created a calculated column = percentdifference({%passed} ,[year asc],-1) and expecting result as shown in green colour highlighted column but i am getting result as shown in yellow colour hi…

Hello. Take the 1st row as an example. It seems your calculation is (92.78%-25.19%)/25.19%, is it correct? But the yellow column title is “percentdifference({%FALE} ,[year asc],-1)”, not sure what this %FALE is calculated.

@Sophia , Yes, my calculation is (92.78%-25.19%)/25.19%, and % FALE (term used in our process) is nothing but % Passed, its my bad missed to edit in header.

How to arrive & % Growth

Q&A

Sophia February 28, 2024, 7:57am 6

Hello. The way you use percentDifference is a bit weird because 2023 and 2024 are not rows in the same table but columns in different tables. Please refer to this: Calculating Percentage Difference - #3 by teja1

Topic		Replies	Views
How to Arrive % Growth Q&A quick-sight , calculations	6	272	November 2, 2023
How to arrive week on week % growth over previous week Q&A quick-sight , calculations	9	306	June 18, 2023
Week over week difference with same calculated field Q&A admin , quick-sight	9	113	February 3, 2025
Calculating Difference in dynamic current week vs previous week where values are in % Q&A quick-sight , calculations , Business-Intelligence-Engineer	6	45	March 21, 2025
Comparison of row total percent between two charts with date Q&A formulas , analysis , quick-sight , visuals , calculations , Business-Intelligence-Engineer	2	376	November 24, 2023

How to arrive & % Growth

Related topics