Forum Discussion
Bar Graph Troubles, incorrect values
Not sure exactly what you're trying to do, but if you're playing with multiple date fields then you really, really need a calendar table to use as your axis
That sounds like my problem...so...I should create a seperate table as a calendar? What do I fill in in that new table? A outerjoin of the two columns of some sort?
Any guidlines?
//Johan
Ok, so I managed to create a new table for the date calender using Date = CALENDAR (DATE(2016;1;1); DATE(2020;12;31)).
But I'm still not given any resonable bar graph. Not it displayes the total count for created date as a flat line for all dates....not "per date" as I want it to be...
I am surley missing something easy and basic but I can't figure out what.
I have tried adding a relationship to my new table as well...no difference...
//johan
You need to make relationships between the calendar table and your date field(s)
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