Analytics
Component
Effort
Property
Assigned
Details
Queries, dashboards, overall usage
Status
Priority
Version
1.0
Itemized list
General High-level Queries
How many bounties were created in Season 1?
How much BANK was allocated for bounties in Season 1?
Sort amount of BANK allocated in Season 1 in descending order.
Number of Bounties at the start of the season vs end of season?
Sort bounties by createdAt, descending
Who created the most bounties?
Display all discord handles who created bounties.
Who claimed the most bounties?
Display all discord handles who claimed bounties.
Who submitted the most bounties?
Display all discord handles of those who submitted a bounty.
Which guild completed the most bounties? (Need to add applicableGuild array or degenericized path)
Bounty Status Queries
How many bounties were completed on time? (compare submittedAt to dueAt)
How many bounties expired? (need to add new data fields)
How many bounties were deleted (past tense)? (statusHistory.status: Deleted)
How many bounties' current status is 'deleted'?
How many bounties are currently opened?
How many bounties are currently 'In-Progress'?
How many bounties were 'In-Progress' (past tense)?
How many bounties are currently 'In-Review'?
How many bounties were 'In-Review' (past tense)?
Guild Specific Queries (need to add GUILD Tags data fields)
How many bounties were created by each Guild? (need to add new data field)
Which Guild created the most bounties?
How many bounties were submitted to each Guild?
Which Guild received the most submitted bounties?
How much bounty reward (in BANK) were given by each Guild?
Which Guild gave the most reward?