duxbuse / ninthage-data-analytics

A better way for the project to ingest tournament results
GNU General Public License v3.0
1 stars 0 forks source link

Wrong data in result field for casual games #104

Closed SanderND closed 2 years ago

SanderND commented 2 years ago

Describe the bug Casual games seem to have incorrect results. Schermafbeelding 2022-01-18 om 21 25 38

In Tableau I calculate the result as follows: {fixed [game_uuid], [army_uuid]: MIN([result])}

I dont pick the average as sometimes there are fields with seem to be grouped and show a multiplied result (e.g. 7 becomes 14). This formula results in strange numbers for the casual games though, as seen in the screenshot. 'Source is the Games with incomplete results' in the tab 'Incomplete Results' in the section 'Quality Monitoring'.