Problem using set analysis with aggregate and rangesum

wayne-a — Fri, 03 Nov 2017 19:29:03 GMT

Hi, I'm creating a chart that uses set analysis to restrict the output. Everything seemed to be working but then I noticed that a dimension value is being returned for items that are being excluded by the set analysis. In the chart image below the hour for 6am shows up but there is no information for 6am based on my set analysis. The information for 6am is for departments not included.

I've tried putting the set analysis right after the AGGR, on the individual counts and on all of them but 6am is always being returned. Here are my AGGR functions for reference. Thanks in advance for any help.

Aggr(RangeSum(Above(Count({$<Department_Name = {'CHEMISTRY','HEMATOLOGY'}>}[Order#])/

Count({$<Department_Name = {'CHEMISTRY','HEMATOLOGY'}>}TOTAL <Date_Receive> [Order#]), 0, RowNo())),Date_Receive,(Received_Hour,Numeric()))

Aggr({$<Department_Name = {'CHEMISTRY','HEMATOLOGY'}>} RangeSum(Above(Count([Order#])/

Count(TOTAL <Date_Receive> [Order#]), 0, RowNo())),Date_Receive,(Received_Hour,Numeric()))

Re: Problem using set analysis with aggregate and rangesum

sunny_talwar — Fri, 03 Nov 2017 19:34:08 GMT

Try to uncheck 'Include Zero Values' undre Add-ons -> Data handling

Re: Problem using set analysis with aggregate and rangesum

wayne-a — Fri, 03 Nov 2017 19:40:19 GMT

Thanks Sunny! That was it.

topic Re: Problem using set analysis with aggregate and rangesum in App Development

Problem using set analysis with aggregate and rangesum

Re: Problem using set analysis with aggregate and rangesum

Re: Problem using set analysis with aggregate and rangesum