back

Goal

         Show how genre trends changes in time.

Creating the Subdataset  

    As we only want the year for this dataset, we extract the year from each entry as the data we are using stores dates in a “YYYY-MM-DD” format.  

    Then, we transformed ranking positions into a score using this rule:
Position 1 → 100 points
Position 2 → 99 points
… and so on.  

    After this, we sum the ranking points for each year across all macrogenres.  

    Next, we created a pivot table to obtain a format suitable for Flourish.  

    Finally, we added a binary indicator:
if the value was different from 0, we assigned count = 1, otherwise 0.


Final structure

Year	The year
A column for each macrogenre	Rank point count per year
Binary indicator columns	1 if present, 0 if absent