Dynamic Filters and Dynamic Data Grouping
Hello team, Hope you are doing well. I have the data where we are getting our ping report for multiple locations and multiple destinations. In the data, I have Start Date and Time, End Date and Time, Location, Destination, Maximum Latency, and Packet Lost. Now, I have to create a visualization where I want to show the 75th and 95th Percentile of Maximum Latency. Also, I have to have a granularity. I can keep Granularity in Slicer. I want here the grouping of the data based on the Date -> Location -> Destination -> Time. The Grouping should happen Dynamically so that I can use fewer charts on my canvas. The granularity we have been asked is like: - If I select Hourly from the slicer then the options for granularity should be 10 minutes, 20 minutes and 30 minutes. If Granularity is 10 minutes then we should get points on the line chart in an hour. The Granularity I have to work on is given as follows: Hourly: - 10 minutes, 20 minutes, 30 Minutes Daily: - 1 Hour, 4 Hours, 8 Hours, 12 Hours Weekly: - 12 Hours, 24 Hours I these as dynamic filtering in all the visuals that I want to present on the canvas. Please help me on how I can do the same.