Forum Discussion
multiple dates on axis
Hi, I have 2 dates that I want to plot on the X-axis and a count of case IDs on the Y-axis. I cant seem to be able to add in more than one one dimension onto the X-axis.
I tried doing what you did but it would give me this error (after I turned off the relationship ) So i just switched it to count of close/create dates
what it would give me if i turned on the relationship
When you say "turned off" the relationship what do you mean? have you removed the relationship (no line) or made it inactive (dotted line)?
Yes these are the same visual.
Yes i have turned it off.
After looking at my data I know what my issue is. 'Case id' on my 'cases' table can be duplicated. Is there a way to have the distinct count of a case id for both 'close date' and 'create date' based on the calendar date? I want to do it this way so I have the calendar date as a single filter for both of it.