Forum Discussion
Apply filters on REST API JSON POST request
Ok i've figured why i had this problem, my segment was set to "one selection" so there was always an item selected, the problem was the api downloaded the report with this selcection, then tried to filter it. i just had to uncheck "only one selection", uncheck everything, save the report, then i could filter my report!
Hi lbendlin and everyone
I have a question, is there anywhere that I can exclude some visuals from being filtered,
for example,
let's say: BOB has 5 restaurent [1,2,3,4,5]
| Restaurant | income | booking |
| 1 | (Nov)1000 | Nov(5),Dec(7) |
| 2 | (Nov):500 | Nov(2),Dec(3) |
| 3 | Nov:400 | Nov(1),Dec(2) |
| 4 | Nov:3000 | Nov(45),Dec(10) |
| 5 | Nov: 2000 | Nov(7),Dec(7) |
BOB needs to export Restaurant 1 in November, but for booking, he wants to see ALL(Oct, Dec).
income values show 1000, but for bookings, instead of 5, it shows 12.
so using the reportLevelFilter, the filter affects all visuals therefore I was wondering if there is a way to exclude some visuals.
Thank you in advance for the one who can show me the way out
regards
Fab
It worked for me, your booking column should be a measure like
booking = CALCULATE(sum(....), FILTER(table, table[month]=selectedvalues(month))
and u can set a segment to select month, call 2 filters in your export, restaurant and month, u should be able to select more than one month.