Forum Discussion
Bar Graph Troubles, incorrect values
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
I'm not sure what you're shoving into your graph but try making a measure to count instances, using the relationship in question for whichever is currently inactive. It sounds like it's using the active relationship for both counts.
When I change the active relationship i get different graphs so I think you are on to something. How can I get it to not use the active relationship for both counts?
I tried adding measurements but it does not seems to make a different...or I did it in the wrong table...or something...