Zoomdata Version

Working with Distinct Counts on Cloudera Impala

Due to the structure of Cloudera Impala, you cannot build the chart using two or more metrics for which the Distinct Count option has been enabled. You can enable or disable the distinct counts for the specific fields in a data source on the Fields page.

Let's consider the following example.

While connecting to the Cloudera Impala data source, for the Actual Sales , City , and County Code fields the distinct counts have been enabled.

Figure 1

On the Bars chart, the City metric has been selected from the list for the Y axis label.

Figure 2

In this case, all the other metrics for which the distinct counts have been enabled, are disabled for the X axis:

Figure 3

These metrics are also disabled in:

  • the Sort by list on the Sort & Limit pane:

    Figure 4
  • on the Color pane:

    Figure 5

Related Topics: