Re: Chart Expression High Level Detail Showing Null
I have attached a sample QVW with the data included.
The screenshot below might explain better.
The top 2 charts have the range conditions applied in the expression. The top left chart only shows rooms which have a value within the range of > 0.5 and < 5%. The top right is the same chart but "rolled up". It is showing the sum of the location as 0.78%. However it should show 0.91 which is the average of room 2, 3, 4 percentages.
The bottom 2 charts are without the range conditions. Room 1 is now displayed as it falls outside the range and the chart is showing everything. The bottom right chart is same as the bottom left just "rolled up". It is also showing the value of 0.78% which is correct for this chart as its the average of rooms 1, 2, 3 and 4.
I hope that makes sense.
Also the below expression has the same result as above.