cartodb: Running two consecutive COUNT aggregations breaks the analysis

Example: Running Points to Polygon analysis (Which can at the moment only be aggregated by count), then intersecting that to obtain a count from a points dataset breaks the analysis & viz. Deleting broken analysis and refreshing page breaks builder.

Error: column "count_vals" specified more than once

double_count_bug

About this issue

  • Original URL
  • State: closed
  • Created 8 years ago
  • Comments: 16 (11 by maintainers)

Most upvoted comments

@saleiva @xavijam In my opinion, this is a key workflow that should be solved. For instance, I have Madrid neighborhoods and a set of points layers such as hospitals, green areas, libraries and so on. I could intersect one by one with the neighborhoods layer, and then use the autostyle to show the variability both geographically and thematic.

What about count_vals_1, count_vals_vals_2 and so on?

+1, BCG also reporting this behavior.