Forum Discussion
Solved
Disable aggregation on visualisation
Hi there, I'm trying to analyze output of load-testing tool by PowerBI - it's simple dataset [unix timestamp; endpoint tag; execution time; status code], but for some reason I can't get an option...
Black_HobbiT Correct, that is your issue. I suggest either removing the duplicate rows in Power Query Editor or using an aggregation like Average or Max or Min instead of Sum.
Greg_Deckler thanks for quick reply, can you clarify point of aggregation in that case - is Average agg for execution time will be AVG(*exec_time) for same timestamp or this is much more complicated?
UPD: I manage to receive unaggregated visualization by chosing Scatter Chart instead of Line Chart even with dupplicates on timestamps - so, looks like if plotting style is "vector" instead of "raster" it is much more demanding for data "quality"