Forum Discussion

sandersonmm's avatar
sandersonmm
Frequent Visitor
4 years ago

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. 
Need Help
Tutorial Requests
jsaunders_zero9's avatar
jsaunders_zero9
Responsive Resident
4 years ago

What is this?

The measures that I gave you should be here.

sandersonmm's avatar
sandersonmm
Frequent Visitor
4 years ago

 

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

 

 

  • jsaunders_zero9's avatar
    jsaunders_zero9
    Responsive Resident
    4 years ago

    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.

  • sandersonmm's avatar
    sandersonmm
    Frequent Visitor
    4 years ago

    Yes i have turned it off.

     

     

  • sandersonmm's avatar
    sandersonmm
    Frequent Visitor
    4 years ago

    jsaunders_zero9 

    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.