In my daily notes, I record the game I played. So, I’ve created this query to count the days I’ve played each game:
TABLE length(rows) as "Dias Jogados" FROM "Experiências/Diário" WHERE jogo GROUP BY jogo as Jogo
When a note has two values for the
jogo (game, in portuguese) field, they are counted as being a different value. For example, if in a note I put this:
jogo:: Genshin Impact jogo:: Minecraft
… this note is not counted as +1 in the “Minecraft” row and +1 in the “Genshin Impact” row, but as one “- Minecraft - Genshin Impact” separated row, like the screenshot:
So, in “Genshin Impact” row, might be 6 on the second column instead 4.
How to resolve this?