Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unexpected visual interaction

I have a report which shows the failed delivery % yesterday split by fail reason. I also have an overall fail 14 day trend line chart. I would like that when I select a fail reason in the table, it filters the chart to the 14 day trend for this reason, but it also filters to just yesterday. Is there anyway I can achieve what I want?

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks for your reply. I sorted the issue by creating a 'Yesterday' measure so I did not need to filter the table.

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi Anonymous ,

     

    Normally to have a trend line for x-days ahead or back you need to have an unrelated date table in order to have the calculation.

     

    Can you share a more details on your data and expected results? How are the visualizations?

     

    If you cna share a sample file and the expected result would be great.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for your reply. I sorted the issue by creating a 'Yesterday' measure so I did not need to filter the table.