I have couple of widget in a datshboard after slicing and dicing the widgets i want to retrieve the left out data points from final widget.

eg: i have 2 widget in a dashboard  first widget shows country and their sales as a bar chart

                                                         second shows city and their sale as a bar chart

so now when i select a country in first widget it will slice the second widget for that country

and the second widget will show all city of that country now i want to extract all these cities and their sale using sisense api.

note: the country selection is not known user can select random country and there might be some more filters.