Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was wondering if it were possible to have a filter pane and line chart on the same sheet. When a value is selected in the filter pane I want the measure in my line chart to sum a total some column in my DB where a value does NOT EQUAL the value from the selected filter pane. I am using #1 below to get a total count of story points based off of the selection in the filter pane (sprint) right now so I would like something like #2 below.
1. Sum({$<project={'Project_NAME'}>}story_points)
2. Sum({$<project={'Project_NAME'}> AND sprint != [Selected sprint from filter pane] }story_points)
I hope this makes sense and any help would be much appreciated. Thank you.
Sorry I would also need it to be based on todays date as well
Sum({$<project={'Project_NAME'}> AND sprint != [Selected sprint from filter pane] AND date is today }story_points)
Maybe :
Sum({$<project={'Project_NAME'} ,sprint=E(), date={"$(=today())" }>}story_points)