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...
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
jthomson
8 years agoSolution Sage
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.