Forum Discussion
Need help on dynamic interactions
Solution SageHi 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.
Hi Thank you for your solution, Unfortunately it is not working :(.
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
Anonymous
you should have a Dimdate table and selected timestamp slicer, should be added to this report using DimDate
- Hi Selva-Salimi, Thank you for the reply, how can we accomplish this?