Forum Discussion

brspencer90's avatar
brspencer90
Frequent Visitor
4 years ago
Solved

How to visualise datetime filtered data from huge dataset

Hi all -    Am running into some issues trying to visualise datetime data from a huge time series dataset. I have about 2.5 million rows of data (about one record every 2s over three months of sens...
Need Help
  • brspencer90's avatar
    brspencer90
    4 years ago

    Hi -

     

    Have found a solution that currently is working. Was worried something like this wouldn't work. Created the following measure : 

     

    WithinRange =
    VAR MinTS = [Min_TS] - TIME(0,0,10)
    VAR MaxTS = [Max_TS] + TIME(0,0,20)
    RETURN
    COUNTROWS(FILTER(compiled_file,compiled_file[timestamp] > MinTS && compiled_file[timestamp] < MaxTS))
     
    Then filter the visual where WithinRange is not blank
     

     

brspencer90's avatar
brspencer90
Frequent Visitor
4 years ago

Hi -

 

Have found a solution that currently is working. Was worried something like this wouldn't work. Created the following measure : 

 

WithinRange =
VAR MinTS = [Min_TS] - TIME(0,0,10)
VAR MaxTS = [Max_TS] + TIME(0,0,20)
RETURN
COUNTROWS(FILTER(compiled_file,compiled_file[timestamp] > MinTS && compiled_file[timestamp] < MaxTS))
 
Then filter the visual where WithinRange is not blank
 

 

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

Thanks for your sharing

  • brspencer90's avatar
    brspencer90
    Frequent Visitor
    4 years ago

    I definitely keep working on a solution after I post these! Glad I found a solution to this one. Hopefully will help someone in the future.