Forum Discussion
FIltering Data by Samples per second
Hi I'm working with a large data set that captures data constantly. I am wondering how to go about filtering the data to only show 2 samples per second instead of every sample that I get in that second?
I am monitoring the data 24/7 so it is always bringing in new information. I want to condense that information as much as possible.
Thank you!
1 Reply
Anonymous If the data is in a relational database eg: SQL Server, then write a custom SQL Query while importing to filter the records (sample 2 records) per second by using RANK. Otherwise, you can also create a new calculated rank column in PBI itself. Anyway, sample data and expected output will help us to understand more details to suggest an accurate solution.
