Forum Discussion
Hitrate from two dates problem
Thank you very much for your answer! :)))
I figured out how to make a date table and I did it (I also made relationships from the Offers -table's "Offer date"-column to Date table's "Date" -column. (Real world table name is 'ekoseer Sopimus' and columns are [Allekirjoituspvm] and [Pvm].) Is this right? (There are some dotted line, but I'm not sure what does that mean.)
Then I made two measures:
Then I'm using filters like this:
For some reason this "Tarjouspvm_laskenta" (offer date) is blank and the other one seems to give some data.
Is there some problem still in relationships?
Thank you! :)))
It seems that this measuring get's stucked in offer confirmation date [Allekirjoituspvm].
I get out only those deals which have some date in the [Allekirjoituspvm] column. If that is empty, it doesnt get in to my list.
what is the logic you want when the offer confirmation date is empty?
The logic is next:
If the deal confirmation is empty, it means it's just an offer. If there is date, it means that deal is confirmed.
Then there is a filter which tells the status of an offer (0 is offer, 1 or bigger is deal). I added that filter to measures.
Do I have to make to data tables?
