Forum Discussion

patfee's avatar
patfee
Frequent Visitor
7 years ago

exclude rows from a slicer

I have two datasets, one with routes and one with landmarks.
The routes contain many lat / lons with timestamps, the landmarks only one set lat lon and one timestamp
Both are joined in one table
Using a slicer, i would like to filter the the routes to a particular day
This works nice, however, the landmarks are lost, as the timestamp of the landmark is outwith the slicer date
Any idea's how i could keep the landmarks in the dataset?

6 Replies

  • patfee's avatar
    patfee
    Frequent Visitor

    something like this

     

    Itemlat lontimestamps
    Route #113.10.110-10-18 10:00
    Route #113.110.110-10-18 10:15
    Route #113.120.110-10-18 10:20
    Landmark #114.01.101-10-18 00:00
    Landmark #29.03.001-10-18 00:00