Percentage all rows of one specific row in that day

Question & Answer
1

I have in data multiple calculation per day and in each day there is also value that is sum of all. How can i calculate this percentage value like in this table:


+------------+----------+-------+------------------------------------------------+
|    date    |   name   | value |                   percentage                   |
+------------+----------+-------+------------------------------------------------+
| 01-01-2023 | name1    |     1 | name1 value / specific value in that day *100% |
| 01-01-2023 | name2    |     2 | name2 value / specific value in that day *100% |
| 01-01-2023 | name3    |     3 | name3 value / specific value in that day *100% |
| 01-01-2023 | specific |   120 | specific/specific *100%                        |
| 02-01-2023 | name1    |     2 | name1 value / specific value in that day *100% |
| 02-01-2023 | name2    |     2 | name2 value / specific value in that day *100% |
| 02-01-2023 | name3    |     2 | name3 value / specific value in that day *100% |
| 02-01-2023 | specific |   300 | specific/ specific *100%                       |
+------------+----------+-------+------------------------------------------------+

My problem is how to select name row with value ‘specific’ for each day.

1 Like
2

Hello @koot - Thank you for posting your query. This can be done by creating a new calculated field. Please find the below snapshot where I have tried to explain how you can implement the calculation to achieve what you are trying. Hope this helps!

image
image1149×428 40.7 KB

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!

1 Like
3

Thank you very much @sagmukhe for your help

1 Like