Forum Discussion
multiple dates on axis
There is a bit going on here, Looking at your model you can set the relationships that I gave you as inactive and the measures will still work as they are calling the USERELATIONSHIP() function.
Hi saunders,
I turned off the relationships and it seems to be working a little better, previously it wouldnt show any of the dates on the bottom. I also wanted to ask if we are using the same visualizations chart as well.
What is this?
The measures that I gave you should be here.
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.