SHOW TAG VALUES Query doesn't work in Chronograf but it does in influxdb-cli/grafana

[UnAfraid]

As title says i have problem executing a query in Chronograf that works just fine in influxdb-cli and Grafana
I am trying to create a variable that contains the current host's core count so i can calculate the CPU utilization on each process

While query works in Explorer

Its a continue from this issue influxdata/telegraf#2020 (comment)
I tried the following queries with and without the "WHERE" clause but results were the same

SHOW TAG VALUES CARDINALITY FROM "cpu" WITH KEY="cpu" WHERE "cpu" != 'cpu-total' AND "host"=:host: -- returns no results
SHOW TAG VALUES CARDINALITY FROM "telegraf"."autogen"."cpu" WITH KEY="cpu" WHERE "cpu" != 'cpu-total' AND "host"=:host: -- returns empty string
SHOW TAG VALUES CARDINALITY ON "telegraf" FROM "cpu" WITH KEY="cpu" WHERE "cpu" != 'cpu-total' AND "host"=:host: -- returns empty string

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[UnAfraid]

Bump

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale]

This issue has been automatically closed because it has not had recent activity. Feel free to reopen if this issue is still important to you. Thank you for your contributions.