Forum Discussion
April Update - Trend Lines
Anonymous - Thanks for trying. I'll leave this up here to see if anyone else has ideas.
On a related, but unrelated to this specific topic question - I currently have to create separate bar charts for the number of items opened by week number and the number of items closed by week number. Obviously these share a common x-axis (week number), but the values for opened/closed should be unique for each week.
When I try to combine these into a single bar chart using a clustered column chart, the count does not work correctly for closed. Every week matches the count of open. For example, let's say I have 156 items opened in week 1 and 86 items closed in week 1. If I create separate charts, this works fine. However, if I try to combine this into a single chart, I get 156 opened and 156 closed (rather than 86 closed as it should be.
Any idea on what could be happening here or how to fix it? Sorry, I know I'm a bit off topic to my original post.
cmfisher82 There are several things that could be affecting the output, the relationships in the model, how you are using things in the visual...
Are you using two different counts? Each count as it's own measure?
What does the relationship look like in the model, is this all one table, are these counts in the same table and do they relate to the same date table?
Some of the above may be off-base, but suffice to say, I need a little bit more info on what your data looks like before I can try to figure out the issue.