How can you compute the percent difference of this table?

Q&A
,
1

so in this case
image

it shows the %difference with dates and the calcualtion I used is

image
image288×178 3.58 KB

Now is it possible to get the percent difference of each ID by date

image
image997×354 41.5 KB

and get the highest percentage of the table?

1 Like
2

Hi @danielreyes3rd,
In regards to the percent difference portion; you could try the following:

Add ‘Process Run Duration’ to the value field well a second time. Then, add a table calculation to the new column:

image
image554×323 34.9 KB

Then calculate as ‘Table Down’:

image
image535×338 36.8 KB

In regards to getting the highest percentage of the table, I tried out a couple different work arounds but there does not seem to be a way to achieve currently in QS.

I’ll mark this as a feature request as well to promote visibility to the AWS support team!

2 Likes
3

Hi @danielreyes3rd,
It’s been awhile since we last heard from you, following up to see if you had any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

1 Like
4

Thanks Brett for the feedback. This is ok

1 Like