I would like to create or show week over week difference in percentage for resolved tickets. The data of resolved tickets week wise is being fetched from single calculated field.
Hi @rawoofar
Please refer to this article about period over period comparison computations. You should be able to get your calculations with the details from the article.
In the event you run into issues and need help with your specific case then you will have to provide more detailed information about your datases and calculations you are performing and the nature of the problem you are facing.
Regards,
Giri
1 Like
These are the fields described in the table and how the table looks.
So I want week over week difference in percentage.
for example week 50 has 31 and week 51 has 22, so in this what will be the week over week difference in percentage wise?
1 Like
Hi @rawoofar
Probably this is what you are looking for?
1 Like
Hi @rawoofar,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
I was not to get what I want
From the table week over week change calculation what I need
Week 51 - 22
Week 52 - 9
Calculation: [(9 -22)/22] x 100 = - 59.09%
This is what I need
Hi @rawoofar,
If you have the calculation that’s needed, have you tried creating a calculated field with that to solve your case? If so, did you encounter issues?
Additionally, if you transition your visual to a pivot table, you can add pre-determined table calculations (including percentile difference), which could work for your case:
Let us know if this works for your case!