Forum Discussion

TonesTables's avatar
TonesTables
New Member
9 months ago
Solved

Line Chart Issue

I'm having trouble with the below line chart. Seeing if anyone could assist to put me on the right track please.    Using these tables with relationships connected, although I can not get all data ...
  • marcelsmaglhaes's avatar
    9 months ago

    Hey TonesTables,

    It looks like the issue might be related to missing data or filters in your model. Here are a few things you can try to troubleshoot the problem:

    1. Check for missing UUIDs or names
      You mentioned that not all rows have a UUID or person's name. If your visual relies on a relationship to a person table (or if you’re using a slicer), those rows might be excluded. Try removing any filters or slicers on people to see if more data appears.

    2. Test your data with a table visual
      Before using the line chart, I recommend creating a simple table visual with the following fields:

      • UUID

      • Event

      • EventType

      • EventDate

      • EventScore

      This helps verify if the expected events are actually present and have valid data (especially EventDate and EventScore).

    3. Avoid overlapping data points
      Since your Y-axis only uses values 1, 2, and 3 (for EventScore), multiple events might overlap on the chart. This can make it seem like some data is missing.

    4. Try a scatter chart instead
      If the line chart still isn’t displaying everything, try switching to a scatter chart with:

      • X-axis: EventDate

      • Y-axis: EventScore

      • Legend or Details: EventType or UUID

    This often gives you a clearer picture when dealing with discrete values like 1, 2, and 3.

    Hope this helps! Let me know if you want help checking your data model or relationships.