Report / Grouping / Sum

[HidayatLalBaz]

Hello everybody,

I hope you can help me out.

I create a report to get a list of countries. In the report, the same countries appear in two different spellings, the German spelling and the English spelling. I would like to summarise the values for the same countries so that I get the sum of both and each country appears only once in the report.

Do you have any idea how I could do that?

I would be very pleased to receive an answer from you.

Many greetings

Hidayat

[EricPartington]

what other meta is common to both those values (spellings) that you could aggregate on instead of country (country.dst is what you are using above or is it a value from another metakey like a firewall or something) ?

[HidayatLalBaz]

Hello Eric,

thank you for your help.

Unfortunately, there are no matches in the other meta fields, so I cannot group over them. 

Exactly, I select via country.src

There is still the possibility to solve the whole thing via a feed, but I don't think that is an elegant solution. Is there a simpler and more elegant way, e.g. via a query or report?

Many greetings

Hidayat