Forum Discussion

Mann's avatar
Mann
Resolver III
6 years ago

Issue with Filtering a Line Chart with Fixed Axis

Hi Guys,   I am showing distinct count of individuals as per time (5min interval) as per zones.   I have three tables: 1) Source: It has data for Individual IDs present in different zones as per...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I would recommend changing your relationship cardinality to single such that the arrow is pointing away from the one and towards the many. 

Not sure if that will solve the problem, but that's a good place to start. There's likely ambiguity being introduced into your scenario.

Mann's avatar
Mann
Resolver III
6 years ago
Hi

I have tried with single filter there but it didnt help. No change.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Can you provide the sample file to take a look at?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        The issue appears to be the date and time relationships. Because you're pulling data from Source and using the fixedaxis table as a dimension, and because those 2 tables don't have a time series link, it's pulling in all the data. 

        I created a separate date table and time table and connected those to the Source table and that seems to work as expected. 

         

        Let me know if this is what you're looking for. 
        https://drive.google.com/file/d/18TbLs7cePoUJC1ObW0YX_Mw3a9ygOGJU/view?usp=sharing