Skip to Content
Sep 19 at 06:14 PM

Counts differ between Story and Datasource table

141 Views Last edit Sep 20 at 07:34 PM 2 rev

Hi Community,

I have created a story in SAC which contains numeric point charts displaying counts of dimensions. Found that the counts differ from the same counts that I obtain on querying the DB table. For instance, If I get a count of 23000 of distinct values of a dimension say 'Contract' on querying the table in datasource, then the value displayed in the numeric point chart using the 'Aggregation' (Count dimensions) option of the calculated measure feature, I am getting a different figure. Please help.