Forum Discussion
output in linechart
MFelix Hi thanks for the help.
After searching on youtube, on how to use multible dates., i found this video. the part about "Usereletionship" solved the issue.
thank you very much.
MFelix Here is the link for my fact tabell file that you can downloade.
My date tabell looks like this.
Hi mathician ,
Looking at your information believe that the issues is regarding the type of information.
If the relationship between Calendar table and the mail table is based on the ML_SENT_TIMESTAMP you have an issue since this includes hours and you calendar table is refering always to 0:00 so heonly picks up the mails send at that time.
Also be carefull if when adding the columns on the line values you are getting distinct count or count.
In the information you have send out since there is only one send date there is a single point on the chart also. Please check the column to wich you are relating the tables.
MFelix Hi thanks for the help.
After searching on youtube, on how to use multible dates., i found this video. the part about "Usereletionship" solved the issue.
thank you very much.
You had your calculations to be made on the inactive relationship, sometimes only seeing the images is hard to figure out how people have their models, but glad you were abble to figure it out.