Pivot totals when no selections

[Anonymous]

Hi All,

Can you please look on the below attached app and see whats the wrong with my expression for sessions.

When i select any Dashboard name or User i can able to see Totals in Session column and if there no selections it is not populating Session Column.

[Anonymous]

I think you need to add aggregation by DocName in the last part.

(If(Dimensionality() <= 1, Sum(Session_Start_Count),

                           If(Dimensionality() = 2,Aggr(Sum(Session_Start_Count),WeekEndDate),

                                                   Aggr(Sum(Session_Start_Count),WeekEndDate,Authenticated_User,DocName))))

[MayilVahanan · Accepted solution]

HI

Can you use simply

= Sum(Session_Start_Count)

can you please explain why you using aggr() in it

[Anonymous]

Good point

Same with the line chart above...

[Anonymous]

Thanks it is working..

Thought of grouping aggregating count at dimension level.

[Anonymous]

Expression in charts are aggregated by dimensions, this is how it works...