Dashboard Creation

[RobinTMavhu]

I hope this isnt too much to ask but i have been stuck for weeks even with the assistance of ChatGPT. So the attached dataset details activity per basestation per hour. basestation can have several cells each with activity. The metrics l want to come up with are as follows:

1. KPIs: i) Sum of the highest connected hourly users per basestation

             ii) Sum of the highest active hourly users per basestation

2. Bar graph: Sum of monthly highest connected hourly users per basestation

3. Line graph: i) Hourly totals of connected users i.e. x-axis (hours), y-axis (connected users)

                      ii) Daily totals of highest connected users per basestaion i.e. x-axis(days), y-axis(connected users)

                     iii) Monthly totals of highest connected users per basestaion i.e. x-axis(month), y-axis(connected users)

[David_Friend]

where are you getting stuck?

[RobinTMavhu]

My set expressions are not producing the results i want. they are as below for the respective graph's y-axis, x-axis isnt a problem.

1. i) max(aggr(sum(MaxConnectedUsers), Basestation, Time, [Date.autoCalendar.Month]))

    ii) max(aggr(sum(MaxActiveUsers), Basestation, Time, [Date.autoCalendar.Month]))

2. max(aggr(
if(len(trim(Basestation)) > 0, sum(MaxConnectedUsers)),
[Date.autoCalendar.Month], Basestation, Time
))

3. i) max(aggr(sum(MaxConnectedUsers), Basestation, Time, [Date.autoCalendar.Date])) 

   ii) max(aggr(sum(MaxConnectedUsers), Basestation, Time, [Date.autoCalendar.Date]))

[RobinTMavhu]

@Kushal_Chawda please come thru, i beg you...

[Vegar]

I think you will get a far way with this measure.

=max(aggr(sum(MaxConnectedUsers), Basestation, [Date.autoCalendar.Date] , Time))

 See attached qvf.

[RobinTMavhu]

Thanks @Vegar those are nice visuals but only the table is giving correct insights the rest of the graphs are missing the point i.e. instead of aggregating the sum of the hour with the most traffic for each day, the expression is only returning sum of the hour with the highest traffic.

[RobinTMavhu]

Yes rightly put, do you have a solution?