Forum Discussion
Hitrate from two dates problem
Hi, I have a table (offers to customers) where are two date datas and if i want to count a hitrate from one month (deals made in that month / offers made in that month) I should made a count from...
Ok. let's take it again:
The situation was this. Every offer hav the offer date and deals have also deal confirmation date. If there is no deal, the confirmation date is empty.
So I have 1 confirmed deal in february and 5 offers made in february.
| Customer | Offer date | Deal confirmation date |
| Cust1 | 1.1.2019 | |
| Cust2 | 2.1.2019 | |
| Cust3 | 3.1.2019 | |
| Cust4 | 4.1.2019 | 6.2.2019 |
| Cust5 | 5.1.2019 | |
| Cust6 | 1.2.2019 | |
| Cust7 | 2.2.2019 | |
| Cust8 | 3.2.2019 | |
| Cust9 | 4.2.2019 | |
| Cust10 | 5.2.2019 | |
| Hitrate in february = 1 / 5 = 0,2 = 20% (cust4 / cust6+7+8+9+10) |
I think I'm very close to the solution.
I made two tests:
1. I made a relationship from the Allekirjoituspvm to Date and filtering worked well.
2. Then I deleted that. (for testing)
3. Then I made a relationship from the Pvm to Date but filtering stopped working. So this can be one reason for the empty measure.
I also checked the date type from Allekirjoitspvm and Pvm, and both are same date -type.
This is interesting...