Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[locust]

Interesting.. Will this work on panes??

Thanks

[MrC]

Please elaborate....

[locust]

For example a pane based on album artist using, GroupCount(...) that will count albums..

So the pane would display Artist (Count)

Similar to the variable expressions you helped me with that counts items within a category.. If possible this way would be much more efficient I imagine rather than using global variables..

[Fabricio]

Please, a picture ...

[MrC]

I posted briefly about this in the Beta forum:

GroupCount() and GroupSummary() can be used ... in a Categories expression by using different expressions to group by and display.  For example:


Expression to group by:
[File Type]

Expression to display....
[File Type] /(GroupCount()/)

This would group by file types, but show you file types followed by the count of the given file type.

[Fabricio]

I understood.
Thank you.

[locust]

Thanks

[locust]

Been monkeying around with this, I can't for the life of me figure out how to sort by groupcount()

Expression to group by
[File Type]

Expression to display
GroupCount():/ [File Type]

So it would display like
250:Mp3
500:Flac

Instead it shows like
500:Flac
250:Mp3

Any ideas? I think it's I thought about also using groupcount in the group by field but no luck.. Is this a limitation?

Thanks

[MrC]

I believe the Group* Functions don't have meaningful values until after the groupings have been created.

The "Expression to display..." is not the sort key, rather the "Expression to group by" is.  But if you place GroupCount() there, the values will all be 1 because the groupings have not yet been made.

I don't think you can use Group* yet in this fashion.

[locust]

Thanks, hopefully this will be added, it's be a shame not being able to sort that way.

I wonder the reason groupcount can't be used in expression to group by.

[MrC]

My hunch is that the software that creates the groupings is at a lower level than the software that later counts those groupings.  Example pseudo-code:

   groupings_list = CreateCategories(current_category_expression)
   category_count_list = GroupCount(groupings_list)

[locust]

so no real workaround without some tweaks.

Would it be possible to add a switch to groupcount, so if you used groupcount in expression to group by, it could add a temp marker later to be replaced by one extra routine that would recalculate the group by field with the replacing the temp markers with the counts from the expression to display.. Like that no major overhaul would be needed.. Maybe a bit sloppy but I can't think of any other logical way without redesign..

[MrC]

The only current means is to use global variables as we've done in other examples.