Forum Discussion

TerCh's avatar
TerCh
Frequent Visitor
1 year ago
Solved

Two graphs from the same table, one including date filter and one excluding date filter.

I am strugeling to show 2 separate graphs from the same table. One graph with a date slicer (via the date table) and one graph that should show all categories excluding the date filter. Both graps should filter by category a visual table (same for both).

Example  table

Purchasing_DocumentDocument_DateOTDOverdue backlog
430000289321.11.2024On Time 
430000251514.06.2024Late >90 Days
430000251514.06.2024Late >90 Days
430000251514.06.2024On Time 
430000251514.06.2024Late >90 Days
430000251514.06.2024Late >90 Days
430000289321.11.2024On Time 
430000289321.11.2024On Time 
460005450911.02.2025Late >90 Days
460004219202.09.2024Late >90 Days
460004825814.11.2024Late >90 Days
460003780309.07.2024Late 30-90 Days
460004564215.10.2024Late >90 Days
460004882921.11.2024Late 30-90 Days
460005526519.02.2025Late >90 Days
460004564215.10.2024Late >30 Days
460004564215.10.2024Late >90 Days
460004649425.10.2024Late 30-90 Days
460004115018.08.2024Late >90 Days
460004564215.10.2024Late 30-90 Days
460001873427.11.2023Late >30 Days
460005450911.02.2025Late >90 Days
460005049916.12.2024Late 30-90 Days
460001623931.10.2023Late >90 Days
460005450911.02.2025Late >90 Days
460005526519.02.2025Late >90 Days
460004564215.10.2024Late >90 Days
460005526519.02.2025Late >90 Days
460005526519.02.2025Late >90 Days
460004975505.12.2024Late 30-90 Days
430000306719.03.2025On Time 
460004649425.10.2024Late >90 Days
460004564215.10.2024Late >90 Days
460004693830.10.2024Late >90 Days
460005450911.02.2025Late >30 Days
460005293122.01.2025On Time 
450091269131.10.2022Late >90 Days
460005049916.12.2024Late 30-90 Days
460005700813.03.2025On Time 
460004975305.12.2024Late 30-90 Days
460004975505.12.2024Late 30-90 Days
450092148301.05.2023Late >90 Days

 

Hope you have a solution for this as I have tried to make a separat table for the other graph, but the data filte still filtering both graphs.

Need Help
  • ToddChitt's avatar
    ToddChitt
    1 year ago

    If you the two visuals are from the SAME table, and that one table is related to a Date dimension, like I suspect it is, AND you have a date slicer on the page, THEN you should be able to manage this is "Edit Interactions" on the XX menu. First go to the Format menu and you will find "Edit interactions" as the first button on the left. Next click on the Date slicer, then for the table where you want to NOT be affected by that slicer, click the "None" icon that shows up in its upper right corner. That icon then switches from a hollow circle with a diagonal line through it to a filled circle to indicate the interaction relationship FROM the Date slicer. Lastly, turn off "Edit interactions".

    Hope that helps.

3 Replies

  • ToddChitt's avatar
    ToddChitt
    Icon for Super User rankSuper User
    1 year ago

    If you the two visuals are from the SAME table, and that one table is related to a Date dimension, like I suspect it is, AND you have a date slicer on the page, THEN you should be able to manage this is "Edit Interactions" on the XX menu. First go to the Format menu and you will find "Edit interactions" as the first button on the left. Next click on the Date slicer, then for the table where you want to NOT be affected by that slicer, click the "None" icon that shows up in its upper right corner. That icon then switches from a hollow circle with a diagonal line through it to a filled circle to indicate the interaction relationship FROM the Date slicer. Lastly, turn off "Edit interactions".

    Hope that helps.

  • TerCh's avatar
    TerCh
    Frequent Visitor
    1 year ago

    Thanks alot. That was a easy solution 🙂