2 Replies Latest reply: Jun 19, 2014 7:44 AM by Александр Закревский RSS

    Strange aggregation results with set analyzis and null values

    Александр Закревский

      I'm, trying to make an several aggregations in a single chart. The aggregated values are from different tables. One of the aggregated values is filtered with set analyzis to count only values that have nulls in parameters fields (CID). So I try to use {$-<CID={'*'}>}. When these aggregations go without additional dimensions, everything is OK, but when with the one the results are unexpected.

      I do expect in the chart "With num" the first Count to be 1 for lines with Num<>null and I don't know, where from the first line with Num=null appears. Maybe something wrong is with my set analyzis? Thanks in advance!