Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI
Can you use simply
= Sum(Session_Start_Count)
can you please explain why you using aggr() in it
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))))
HI
Can you use simply
= Sum(Session_Start_Count)
can you please explain why you using aggr() in it
Good point
Same with the line chart above...
Thanks it is working..
Thought of grouping aggregating count at dimension level.
Expression in charts are aggregated by dimensions, this is how it works...