Count unique, Based on lines large than an Average Formula in Gauge

[Tobievr]

Hi

I am very new to QlikSense. I have a table and in this I have a Start and End Date and this works out an Average for everything. What I need to do, is count the transactions that are larger than the Average.

Current Dimension Formula:

=avg(if(NetWorkDays(WAYBILLDATE,PODDATE)>'','',NetWorkDays(WAYBILLDATE,Today())))

Average Could be 3, so all transactions that is greater than 3 based on above formula, must be displayed in a KPI Chart. 

I am note sure if the above is sufficient information, but would appreciate feedback or assistance with this.

Thank you

[Yoshidaqlik]

Hi,

I'll put an example that maybe you can adapt to what you need

In this case, the days that have a transaction count greater than the average expression you entered are counted.

sum(
  aggr(
    if(
      count(transaction)
      >
      avg(total
          if(
            NetWorkDays(WAYBILLDATE,PODDATE)>'','',NetWorkDays(WAYBILLDATE,Today())
          )
      ),
      1
    )
  ,dimension_date)
)

Regards