I am having some issues with a table that will tell me the number of errors and the percentage all in one field. I was able to do this for a separate table, but since this table is set up a little different, I am having some issues.
I am trying to show the last few days of data as a dimension and separated by area.
My expression for the measure is as followed (side note: the first if statement I tested Area 8, showing true to the above image, first step was to test the sum of all Area's, then from there I would add the division to get actual percentage, if there are any tips or any other ways to do this, please help, Thanks):
Attached is a sample file with the same issue. Based on the data, the result for 9/3/2018 - area1, should read " 5 errors / 16%", 9/4/2018 - area1, should read "7 errors / 17%", and 9/5/2018 - area1 should read "4 errors / 18%"
Again, I'm sure there's a lot easier way of doing this, i'm just stuck with this one.