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