I have one line in my chart to show count of usage that is high during that hour,minute etc.But in case of zero values line chart doesnt come to zero, i tried if expression result zero than zero else expression, but still line chart dint show for null values. any other way is it possible?
Yes i unchecked ...no data available in data file for those particular axis.............for exp for 0 hour 1 hour usage of high measure is not entered in data file
so then it means you have null data, QV is not going to show anything for it since the data does not exist
might be worth creating a master calendar with hours, this way you can look for entries with a null value another option would be add a row with a zero value for that specific period, this seems simple but you have to take into consideration if you are doing counts as this could skew those numbers
