Order a repeating group of one datatype based on a related data type

Need help
1

Hi there,

I have an app with songs. When a user listens to a song it creates a listened to data type which has the songsID and the Date/time of the listen.

I want to make a weekly top charts. How do I go about ordering a repeating group of songs based on the number of listens (from the listens data type)?

Any help would be appreciated. Even advice on a better way to organize a listened to recording system.

Many thanks,
Johnny

2

Use the grouped by operator

3

This topic was automatically closed after 70 days. New replies are no longer allowed.