I have a series of data that I load daily with the following information:
- assigned quota
- quota used
- last connection
I'm trying to create a series of dashboards to graphically collect some results that we need to display.
The graph that I am trying to assemble is to get the top-10 of users with the most quota used. Monto graphs it by facing the user with the last_value field (assigned quota). The problem is that if I configure this graph in this way, it draws the first 10 users ordered by the "username" field, so I cannot see the users with the highest quota used. However, if I calculate the median or the mean of the assigned quota field, it does show me the users not sorted alphabetically but by the value of the calculation of this field.
Is there any chance that using "last_value" doesn't sort me by username? Last_value is the most real value that I can obtain and the one that I would be most interested in showing in the graph.
Thank you very much in advance.