Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Changing visual to a single object

Hi guys,   I have a situation but having difficulty what the actual problem is, so I used a generic title hoping it would be accurate.   I have tables as follow(Car.CarId references to CarDetails...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

Thank you for providing the sample data. That helps a lot with proposing a potential solution.

 

Your problem is that you have blank TrainStateIDs in the LogItems table. Please explain/correct.

 

There is another problem - a bug in the Small Multiples view - it does not properly show x axis if the value is time only (without a date).  Converting the time to decimal works.

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your reply!

Not all LogItems does have TrainStates. The empty ones are part of another datasets.

I noticed the Small Multiples View having issues with the x axis and I couldn't fix it. Converting to decimal is not really a solution I like. I don't understand why the x axis scale wouldn't go from lowest value to highest value in the GameTime column?

The visual that you posted misses the 'Accelerating' column. With this, the column stacks have different colors based on the IF statement. (Accelerating, Decelerating, Stable). 

I also tried to make it work without Small Multiples Views and by using a slicer to only show 1 Train object. I failed in that too.