Count Unique Values in Pivot Table

[pxlmedia]

I have a pivot table with rows, grouped by date. I'm trying to count the unique values of a column for that date. COUNT (DISTINCT[@field]) just returns Error in formula. even though it verifies its a valid formula before previewing.

[Nuke354]

Hi there. May I know more on the how you're adding the SQL query in your pivot table? Have you also tried to use a Tabular Report and insert a Calculated Value instead?

[cheonsa]

Hi @pxlmedia,

Here is the correct syntax that you can use:

SELECT COUNT (DISTINCT[@field])

Cheers!

[Kurumi]

Hi everyone! Just an update: Caspio has finally released a feature to show DISTINCT records on Reports (Tabular/List/Gallery).

It is available in R30 version: https://howto.caspio.com/release-notes/caspio-30-0/