search

DataBrewery / cubes

[NOT MAINTAINED] Light-weight Python OLAP framework for multi-dimensional data analysis
http://cubes.databrewery.org
Other
1.49k stars 313 forks source link

Specify sort order in HTML? #478

Closed dfrankow closed 4 years ago

dfrankow commented 4 years ago

This URL works on my cubes server (using this music database):

http://localhost:5005/cube/InvoiceLine/aggregate?drilldown=TrackId_AlbumId_ArtistId&order=UnitPrice_sum

However, it sorts ascending. I want descending. Is there a way to give the sort order to this URL?

ThamaluM commented 4 years ago

Hi @dfrankow try this. http://localhost:5005/cube/InvoiceLine/aggregate?drilldown=TrackId_AlbumId_ArtistId&order=UnitPrice_sum:desc This works for me.

dfrankow commented 4 years ago

That worked. Thanks!

I wasn't able to find docs about that anywhere.