Ability to aggregate on a field in a chart without data being fed from Data section
Currently, there is no way to get an accurate COUNTDISTINCT('field') value in the charts section when the report has several fields. The result is '1'. If you SUM it up it counts the rows from the data section, and doesn't return the actual distinct results in the given field.
Example: I made a table in a report. The table has a column called country code. There are other columns in the table, so in some cases the country code is repeated. There are 112 rows in the table and 76 different country codes.
I added a total to the country code column using count distinct. The total shows 76, as expected. However, I want to create a big number chart to show the number of countries. I added an advanced function in the chart for country code and selected count distinct. I added that to the horizontal axis. The resulting number is 1. I changed the aggregation type to sum and the number changed to 112. No matter what I do, I cannot get it to show 76. I also tried adding a distinct count of country code as a column in the report, then adding that to the chart, but the result is the same. I tried both auto chart and explicitly selecting numeric display. The results were the same.