Average value in barchart

[stekol61]

Hi!

The enclosed .qvw has a simple barchart.

What I want is that the red bar always show the avaerage value for the selected period.

It should reflect the changes of "Node" and/or "Technology" but not changes of "Date(s)"

How can this be done?

[sunny_talwar]

May be this?

Sum({<Date>}[Period Duration]/1440)

[stekol61]

Sum({<Date>}[Period Duration]/1440)

seems to give a totlal value for the period.

What I need is an average value for the period. Changing "Sum" to "Avg" doesb't seem to help.

The correct value for node "B" and Technology "4G" should be around 29000

[sunny_talwar]

May be try this

Avg({<Date>}Aggr(Sum({<Date>}[Period Duration]/1440), Date, Technology, Node))

[stekol61]

Grate!.

This solved my problem

[sunny_talwar]

I helped resolved and I get neither correct, nor helpful response .... Just kidding, but jokes apart, it would make sense to mark true correct and helpful responses for future users.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny