Forum Discussion
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...
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