Mismatch of Data in Front end and Backend Aggregations

[kumar2]

Hi,

I am trying to optimize the dashboard size by moving the aggregations to Backend of scripts, while doing this i am facing some issue.

please find the below sample data

S1:
Load * Inline [
Column A,Id,B
A,100,x
A,101,y
A,102,x
B,103,z
B,100,x
C,200,y
D,101,x
];

In the UI calculating the count of distinct Id's  by using the formula ----------- Count(distinct Id)=5

when i am applying the same formula in the backend the count is coming as  "7"  which should be "5"

S2:
Load
"Column A",
B,
Count(DISTINCT Id) as Count
Resident S1
Group by "Column A",
B;

Drop Table S1;

This is because of Grouping of the dimensions "Column A" and "B"

Is there a way how to achieve this same count function in the Backend

Note:- The value should change when i select the dimensions

Thanks