Sum( aggr(max())) Expression in Combo chart

[cbaqir]

I have exhausted every possibility I can think of with this and hope it's obvious to someone else...

In my attachment, I have two graphs. The first graph shows Allocated vs Actual Non-PTO vs Actual PTO hours.

The second graph shows the Allocated vs Actual Non-PTO vs Actual PTO FULL TIME EQUIVALENT (FTE) resources.

I have no issues with either of the Actual expressions but the FTE expression produces a null resort for Allocated hours.

The only difference is the denominator.

Hours chat:  sum(ALLOC_HRS)

vs

FTE chart: sum(ALLOC_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR,FLAG)) 

Someone please help me correct the err of my ways!

TIA

Cassandra

[cbaqir]

No one?

[settu_periasamy]

Hi,

I think, you just missed to look into the Field Name. (it is case sensitive)

in your expression, it is FLAG instead Flag

FTE chart:

sum(ALLOC_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR,FLAG Flag))

[sasiparupudi1]

Hi

as  mentioned in the post before, your "Flag" field is not the same in your expression

FTE chart: sum(ALLOC_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR,Flag)) 

If you got your answer,please close this thread by marking the correct one

Sasi

[cbaqir]

Thank you for that (duh). That did fix the issue in my sample app. Unfortunately, this does not solve the issue in my real dashboard.

This is the expression in my FTE chart in the real dashboard for Allocated (not working): =(Sum({$} ALLOC_HRS))/sum( aggr(max(MONTH_CAP), FISCAL_MONTH_YEAR ,FLAG_PTO))

Working:

Actual FTE: =(Sum({$<TASK_NAME-={'PTO'}>} ACT_HRS))/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR, FLAG_PTO))

Actual PTO: =Sum({$<TASK_NAME={'PTO'}>} ACT_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR, FLAG_PTO))

Capacity: SUM (ADJ_CAP)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR, FLAG_PTO))

Dimensions:

=date(FISCAL_MONTH_YEAR, 'YYYY-MMM')

=alt(FLAG_PTO,0)

This is the expression (that works) in my hours chart: =Sum([ALLOC_HRS])

There must be another reason...

[settu_periasamy]

Hi,

Just testing purpose can you remove {$} from sum expression

Try like

=(Sum({$}ALLOC_HRS))/sum( aggr(max(MONTH_CAP), FISCAL_MONTH_YEAR ,FLAG_PTO))

Edit:

=Sum(ALLOC_HRS)/sum( aggr(max(MONTH_CAP), FISCAL_MONTH_YEAR ,FLAG_PTO))