
1. Re: How to normalize ratio values for dynamic range
Jonathan Drummey Oct 5, 2018 1:52 PM (in response to Marcin Tymczak)Hi Marcin,
Without seeing a packaged workbook we can be of limited help...this sounds like a good a good place for a table calculation (or some combination of EXCLUDE and INCLUDE Level of Detail expressions. Table calculations are computed after most all other calculations are completed so they avoid the filter challenges of FIXED LODs.
([Error Count]  WINDOW_MIN([Error Count])) / (WINDOW_MAX([Error Count])  WINDOW_MIN([Error Count])) would do a linear scaling, you'd set the compute using all the dimensions in the view that you want to include as part of the scaling computation.
Jonathan

2. Re: How to normalize ratio values for dynamic range
Drew Glover Nov 27, 2018 12:34 PM (in response to Marcin Tymczak)Hi Marcin,
Try this:
[Error Ratio]*(1/WINDOW_MAX([Error Ratio]))
This will work to normalize an aggregate field on a scale to 1. To increase the scale, just change 1 to what you'd like it to be. For example, for a scale to 10, replace 1 with 10. Hope this helps!

3. Re: How to normalize ratio values for dynamic range
Ciara Brennan Dec 5, 2018 8:30 AM (in response to Marcin Tymczak)Hi Marci, just checking if this is now resolved?
Thanks, Ciara