Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Need help on dynamic interactions

Hi,    I have a table visual which has a timestamp column and a line chart with same timestamp column in X axis. Now when I/end user click on any time stamp value I need the line chart to display ...
Selva-Salimi's avatar
Selva-Salimi
Icon for Solution Sage rankSolution Sage
2 years ago

Hi Anonymous 

 

you should use a measure to calculate the Y-axis value. you can write the measure as follows : (lets assume thatyou have sales data)

 

measure sales_in range := calcualte (sum(sales) , filter (all(table) , timestamp>= selectedvalue(timestamp) - 5 &&  timestamp<= selectedvalue(timestamp) + 5)

 

If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Thank you for your solution, Unfortunately it is not working :(.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      when I select only one timestamp due to interaction it is filtering to only one point in line chart, if I block interaction it is not working

       

      • Selva-Salimi's avatar
        Selva-Salimi
        Icon for Solution Sage rankSolution Sage
        1 year ago

        Anonymous 

         

        you should have a Dimdate table and selected timestamp slicer, should be added to this report using DimDate