Data analysis within a quarter for Kandy #72

Open
opened 2024-07-26 14:48:58 -04:00 by dakiny · 3 comments

I would like to gather data to be able to pull from the bot a data analysis:

  • Selection of one or more previous terms;

Show the following data:

  • max points with hosting: 99 (dakname);
  • max points without hosting: 99 (dakname);
  • max points non-council, non-legacy: 99 (dakname);
  • average: 99 points;
  • median: 99 points;
  • events hosted by council (multiple hosts): 99 events; [count events and check which ones were hosted by Dak Bot]
  • guests that attended event: 99 guests; [count attendees that don't have @clan_member]
  • clan members that attended event: 99 clan members; [count attendees that have @clan_member]
  • non-council, non-legacy, clan member that attended events: 99 clan members; [count attendees that don't have @dakiny_clan_council, @emeritus]*
  • hosts: 99 hosts (dakcouncil, dakothercouncil, daklegacy) [count and list all hosts]
  • non-council, non-legacy, hosts: 99 hosts (dakname, otherdak, dakname2) [count and list all hosts that don't have @dakiny_clan_council, @emeritus]*

*those would bring up data only based on current clan council and not clan council of the time of that quarter... We need to think about it more.

Feel free to add any other data analysis that would be good for figuring out which events are working or not working.

(~Kandy)

I would like to gather data to be able to pull from the bot a data analysis: - Selection of one or more previous terms; Show the following data: - max points with hosting: 99 (dakname); - max points without hosting: 99 (dakname); - max points non-council, non-legacy: 99 (dakname); - average: 99 points; - median: 99 points; - events hosted by council (multiple hosts): 99 events; `[count events and check which ones were hosted by Dak Bot]` - guests that attended event: 99 guests; `[count attendees that don't have @clan_member]` - clan members that attended event: 99 clan members; `[count attendees that have @clan_member]` - non-council, non-legacy, clan member that attended events: 99 clan members; `[count attendees that don't have @dakiny_clan_council, @emeritus]*` - hosts: 99 hosts (dakcouncil, dakothercouncil, daklegacy) `[count and list all hosts]` - non-council, non-legacy, hosts: 99 hosts (dakname, otherdak, dakname2) `[count and list all hosts that don't have @dakiny_clan_council, @emeritus]*` *those would bring up data only based on current clan council and not clan council of the time of that quarter... We need to think about it more. _Feel free to add any other data analysis that would be good for figuring out which events are working or not working._ (~Kandy)
Owner

Hmm, I don't currently have a system for tracking hosts for the first two data points. Would need to update the command to track that. Likely would need to actually track all this data in a table. Easy to do, just need to do it. I was just adding points for people rather than track the host and attendees in a table.

Hmm, I don't currently have a system for tracking hosts for the first two data points. Would need to update the command to track that. Likely would need to actually track all this data in a table. Easy to do, just need to do it. I was just adding points for people rather than track the host and attendees in a table.
imcompiling added a new dependency 2024-07-29 11:31:54 -04:00
Owner

Other data points could have to do with event types. Total events of each type, average attendance for each type. This data would come from the list added in #67.

Other data points could have to do with event types. Total events of each type, average attendance for each type. This data would come from the list added in #67.
Owner

Could potentially add something that would track interest vs attendance if #59 gets set up and working.

Could potentially add something that would track interest vs attendance if #59 gets set up and working.
Sign in to join this conversation.
2 Participants
Notifications
Due Date
No due date set.
Depends on
#67 Record events
imcompiling/dakiny-bot
Reference: imcompiling/dakiny-bot#72