Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have some data visualized in Power Bi using R scripts (ggplot2 library). Field data (two variables, y as a function of x, black points) and two constant theoretical curves (red).
In order to compare the field data with the theoretical curves, I would like to obtain the maximum and minimum y values per x value per day. For example:
The objective is to obtain "envelope" curves, get rid of the rest of data and compare them in one visual respect to the theoretical curves.
Any ideas? How can I obtain the values in R script or in the query?
Thanks
@Jond ,
I think you can use dax instead, could you share the sample data and the output result?
Regards,
Jimmy Tao
I share some sample data (raw and sample report):
https://www.dropbox.com/sh/6lxcf9dj4v0yjoa/AAB8ClxYanQ70P5f73uwxbtga?dl=0
This should be the output result:
For each x value, the maximum and the minimum of y are stored and the rest of the data is discarded. The figure shows the maximum and the minimum values of y for a range of x. Each color is a different day.
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |