help with min/max and avg on chart

[hopkinsc]

hi all, i have a chart in the attached qvw which has an expression giving me actuals.

I need to add expressions to show the min/ max and avg but i am not getting much luck in getting it working.

Can anyone help please?

[MK_QSL · Accepted solution]

=Min(Aggr(COUNT(Type),Hour))

=Max(Aggr(COUNT(Type),Hour))

=Avg(Aggr(COUNT(Type),Hour))

=Min(Aggr(Count (Type)/Count(DISTINCT Date),Hour))

=Max(Aggr(Count (Type)/Count(DISTINCT Date),Hour))

=Avg(Aggr(Count (Type)/Count(DISTINCT Date),Hour))

If you want to show for TOTAL.. use as below

=Min(TOTAL......)

=Max(TOTAL.....)

=Avg(TOTAL......)

[jyothish8807]

Hi,

Add these as Expression

=Min(Aggr(COUNT(Type),Hour))

=Max(Aggr(COUNT(Type),Hour))

=Avg(Aggr(COUNT(Type),Hour))

And in dimension put:

User

That will give you 3 lin charts for all users.

Regards

KC

[jyothish8807]

Sorry, use this:

=Min(Aggr(COUNT(Type),User))

=Max(Aggr(COUNT(Type),User))

=Avg(Aggr(COUNT(Type),User))

And in dimension use:

User