Hi - I am creating a table that displays different country codes in the first column (e.g. GB, DE, AUT, etc.). In the second column, I want to show all open tickets for the respective country code. Therefore, I have a data source that contains a row with the values "open" and "closed" for each ticket assigned to a specific country code.
Now, in Klipfolio, I use the following formula: GROUPBY(slice(@country_code), COUNTIF(@status="open")).
Unfortunately, the result does not even come close to the correct number of open tickets for each country code.
Do you have any idea how I can fix this problem?