Forum Discussion

DoctorYSG's avatar
DoctorYSG
Helper III
2 years ago
Solved

TOPN() for Netsted Table?

I am looking to pull the top 100 users by usage out of this Summary table. So there is going to be way more than 100 rows, since each of the top 100 users are going to have nested rows with other information. Is there a way to do this? TOPN seems to just get the top N rows:

 

User Usage = 
VAR sumTable =
    SUMMARIZE(
        Telemetry,
        NodeInfo[UserTitle],
        NodeInfo[Application],
        NodeInfo[OS_DISK_TYPE],
        NodeInfo[DEVICE_MEMORY],
        NodeInfo[EITaaS],
        NodeInfo[Web],
        "WaitTime", CALCULATE(SUM('Telemetry'[WaitTime]) / (60 * 60 * 1000), 'Telemetry'[Used]),
        "UsedTime", CALCULATE(SUM('Telemetry'[UsageTime]) / (60 * 60 * 1000), 'Telemetry'[Used])
    )
RETURN
    TOPN(10000,
    sumTable,
    [UsedTime], DESC
    )

 

 

1 Reply