Forum Discussion
johanhallin
8 years agoFrequent Visitor
Bar Graph Troubles, incorrect values
Hi, I have search the forum but not found anything around my problem so I am hoping for some help. I have a table with many columns where two are of interest, CreatedDate and MovedDate. Both contai...
jthomson
8 years agoSolution Sage
You need to make relationships between the calendar table and your date field(s)
johanhallin
8 years agoFrequent Visitor
Yeah, I figured that too...but it did not solve my problem. Now both the CreateDate and the MovedDate shows the same count even if the raw data shows that MovedDate count should be 15 and the CreateDate count should be 5.
I can't have two active relationships, but I have one active and one inactive relationship between these two tables now. The bar graph displays the values for CreatedDate and MovedDate as the same value, altogh different for each day...
//Johan