KNOWLEDGE BASE

Error "Abstract query HAVING filter is not aggregate"


Published: 05 May 2015
Last Modified Date: 30 Aug 2016

Issue

When using a filter on a field used in a LoD calculation while in a live database connection, the following error might occur:

An error occurred while communicating with the data source.
Abstract query HAVING filter is not aggregate.

Environment

  • Tableau Desktop 9.0
  • EXASolution
  • MSSQL

Resolution

As a workaround, use one of the following options:
  1. Use an extract of the data source instead of a live connection.
  2. If possible, change the filter to a context filter by right-clicking the field in the filter shelf and selecting Add to Context.
Did this article resolve the issue?