Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a KPI for calculating number of orders.
=Count ({$<Status={Finished}>} ID) - This KPI gives 25900
I am creating a table with 28 columns and no filter applied. But if I download the table into excel I can see only 20875 records. I have a dimension called status where I am using the expression if(Status = 'Finished', 'Completed'). I am not writing any expression in other dimensions.
I want to know where I am losing around 5000 records.
Please do help.
Thanks.
Perfect. I understood that all the dimensions has to be added to match with KPI value.
Thanks.