Forum Discussion

Walt1010's avatar
Walt1010
Icon for Helper V rankHelper V
2 years ago
Solved

Driving 2 Charts with a Data Slicer

I have 2 table charts, depicting incoming and outgoing callls by date. The actual data for these 2 is stored in 2 separate tables. I've created a data table and linked the date values in the 2 tables...
Need Help
Tips and Tricks
  • Alican_C's avatar
    Alican_C
    2 years ago

    It sounds like the issue might be related to how the relationships between your tables and the date table are set up, or how the filter context is being applied. Here are a few steps to troubleshoot and resolve the issue:

    1. Verify Relationships:

      • Ensure that the relationships between your date table and the incoming/outgoing calls tables are correctly set up.
      • Both relationships should be "Many to One" (Many in the calls tables to One in the date table).
      • Make sure the relationships are active.

    2. Check the Date Format:

      • Ensure that the date format in the date table matches the date format in the calls tables.
      • Sometimes discrepancies in date formats can cause filters not to work as expected.

    3. Use Correct Date Column in Slider:

      • Verify that the date column you are using in the slider is from the date table.
      • Ensure that the date slicer is set to filter by the correct date column.
Alican_C's avatar
Alican_C
Icon for Resolver II rankResolver II
2 years ago

It sounds like the issue might be related to how the relationships between your tables and the date table are set up, or how the filter context is being applied. Here are a few steps to troubleshoot and resolve the issue:

  1. Verify Relationships:

    • Ensure that the relationships between your date table and the incoming/outgoing calls tables are correctly set up.
    • Both relationships should be "Many to One" (Many in the calls tables to One in the date table).
    • Make sure the relationships are active.

  2. Check the Date Format:

    • Ensure that the date format in the date table matches the date format in the calls tables.
    • Sometimes discrepancies in date formats can cause filters not to work as expected.

  3. Use Correct Date Column in Slider:

    • Verify that the date column you are using in the slider is from the date table.
    • Ensure that the date slicer is set to filter by the correct date column.
Walt1010's avatar
Walt1010
Icon for Helper V rankHelper V
2 years ago

Thanks! Your structured answer made me work methodically through the options. My problem was a different format in one of the tables that I'd known about but kinda dismissed as not being an issue:)