Missing value

[#1]

We use an expression to check whether a particular or multiple  reports have been updated in a given time interval. We have created a cyclic group with the Day, Week and Month dimensions. The expression below works properly when we select multiple reports and displays the total number of reports updated in the given time interval. However, there's a problem when only selecting one report that hasn't been updated at all, at a given day. Then that day is omitted from the chart and when calculating weekly percentage updated reports the day without updates is omitted.

=SUM(aggr(COUNT({$<Year = {"$(#=Max(Year))"},WeekDay -= {'sat', 'sun'}>}DISTINCT QVD_Id),Month,LoadDay))/(COUNT({$<WeekDay -= {'sat', 'sun}, Time=,Day=>} Month)*GetSelectedCount(QVD_Id))

For example, as you see in the image below, when we select one report with the following time intervals, it does not show a value of zero for "5" - which is a Friday. It shows zero for "4" and that is because the report was updated after 5am but on Friday the 5th there was no update. We want the chart to show a value of zero for Friday as well.

Hope you can help us! Appreciate it!

[rohit214]

Hi,

Just check the option show all values in presentation tab.

Regards

Rohit

[#3]

Just in case, check that the value 5 exists on your data for that dimension. If it's there, check the box "show all values" from the Dimension tab on the properties of the chart:

[#4]

Hi Jose,

Thanks for the suggestion however we have already checked this option. We know that 5 exists, but we are more concerned about our expression and whether it disables values like September 5th (that have null values) to appear on the chart.

Thanks again for the suggestion 😃

[#5]

Thanks you but we have already checked this option. We know that 5 exists, but we are more concerned about our expression and whether it disables values like September 5th (that have null values) to appear on the chart.