Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
In my table i am having two date
1.order date
2.Delivery date
but when i am using Canonical Date the count of delivery not coming correct as per my source
Please provide some more information.
1. A screenshot of your data model.
2. The expression you are using as Count of Delivery.
3. Expected and actual results.
-Rob
OUTCOME- i am creating a Pie chart where i am showing Count of ( Order deliver id ,order Ship id and Order id) show i need a year fliter of it when ever i click on year it will filter out the pie chat
I still feel like you have not provided enough information to fully address your question. But if I had to guess you are getting an incorrect result -- too high -- from Count([ORDER ID]). It's always a bad idea to count key fields because it's ambiguous as to which end of the connection you are counting.
If the ORDER ID count is where you are having problems, try
Count(Distinct [ORDER ID])
If this did not resolve your problem, please provide the actual expression text and the expected and actual numbers.
-Rob