Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Last 10 calls

Hi All,   I am woring on a Report to analyze calls and their details.. where we have calls shown hourly, daily and monthly basis..   I have a requirement, where I need to create reports for last ...
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, Anonymous 

    You can sort the data based on the date/time column and add an Index column in PQ.

    Then you can try to get the result table using the function TopN.

     

    Result Table = TOPN(10,'Table',[Index Column],DESC)

     

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous 

You can sort the data based on the date/time column and add an Index column in PQ.

Then you can try to get the result table using the function TopN.

 

Result Table = TOPN(10,'Table',[Index Column],DESC)

 

 

Best Regards,
Community Support Team _ Eason