KNOWLEDGE BASE

Error "Indices and schema must have the same datatype" Selecting Data Points As Action Filter


Published: 25 Jul 2013
Last Modified Date: 04 Sep 2015

Issue

When selecting multiple data points as an action filter on a worksheet in a dashboard, the following error might occur:
 
Indices and schema must have the same datatype.

Environment

Tableau Professional

Resolution

Update the calculated field to return only numbers rather than NULL with values. For example:
if <parameter name> then
    if <field name> then
        1
    else
        0
    end
else
    0 
end

Additional Information

Although the formula above uses 0, any integer number can be placed there.
Did this article resolve the issue?