Introduction

In this dashboard, my effort was to study and analyze the results of the contest that was held on the Flow Blockchain last month (Feb 2023) in order to provide the audience with a personalized view of the performance and efficiency of this hackathon held.

Flow Hackathon 2023

• Contest Overview

The Flow Foundation Hackathon is an innovation challenge in which winners are determined solely on the basis of skill. The objective of the Contest is to leverage Flow’s platform to build solutions that respond to certain prompts provided by the Administrator. The Contest requires competence in the areas of design/UX, development, and understanding of the Flow platform.

• Website
• Calendar
• Contest Doc

Methodology

• The source tables which I used:

flow.core.fact_events and flow.core.fact_transactions

• Table pages:

1. introduction
2. Hackathon Event (The Analysis)
3. Conclusion

• What I've Done:

first I select my time frame based on the Flow hackathon schedule (02/10/2023 - current day) then break it into 3 phases (education, submission, and launchpad) then I s count unique TX_ID from flow.core.fact_events and limiting the result by filtering event_type into AccountContractAdded. then I calculate the cumulative that I needed for the first section of my table. then for the next section of the Hackathon Event tab and user activities, I used the EVENT_DATA column of the flow.core.fact_events table and joined it to the flow.core.fact_transactions table, then by using the TX_ID and thePROPOSER column I did calculate the user activities.

Authur Contact Info

This dashboard was created by CODXIII you can contact me via discord: CODXIII#8204