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
