I have a timeseries data set and am using what in my field we refer to as a digital filter to smooth the data. I have water level data and it can be quite noisy so the filter acts as a smoother. I use the following equation: (Summation( i = 1, 96, Lag( :Water, i ) ) +Summation( i = -1, 96, Lag( :Water, i ) )) / 192. The equation is looking forward 96 rows and backwards 96 rows and taking the average. The equation works just fine except for at the beginning of the dataset... for rows less than 96 it tails off to 0. How can I either adjust the equation or add to say If row < 96 then only take the average of row 1 through row i (i being a value between 2 and 95) ... View more

I am trying to script a fit X by Y with a by variable, then fit each with a polynomial (degree = 2)  and then extract the "summary of fit" data (specifically the R Square and number of observations) to a data table. As an example I was working with the Car Physical Data sample set. For example use Weight as the Y, Horsepower as the X, and Type as the By. Then fit with each group with a 2nd order poly. extract all summary of fit diagnostics using make combined data table. I know how to do it with the gui but need to script it to perform much larger operation.  ... View more

I am trying to run an ANCOVA on a dataset with a continuous Y variable (streamflow) and a continuous X variable (Precipitation), additionally I have two categorical variables "Period" (A and B) and "Station" (1, 2, 3, 4, and 5). My goal is to explore the relation between streamflow and precipitation within each period - comparing the slopes of those relations across stations, and then compare the slopes of those relations within each station across the periods. The kicker is that I already successfully did this over a year ago, I have the results, but now I need to rerun it and I have no idea how I did it. I assume its in fit model but I've got a brain block at the moment.  ... View more

I have a script in which there is a for loop that is running through a number of "monitoring stations" and generating plots examing relations between various parameters.  These are then journaled together by station., subsquently producing a data review package for later use.  I use this script for reviewing the data that I get back from my laboratory.  As of now these journals are static. It would be very helpful if they could be dynamic in such that I could click on a data point that looks funky and have that point/row highlighted in my associated data table. I've had trouble searching for this online, help! ... View more

I am trying to create a worksheet to keep track of sample count. I have columns for Site Name, Quarter, and several other informative stats. I want to create a column that will update each time a new sample is added(i.e. 1, 2, 3... ) I have 12 sites, each of which I want the sample counter to be exclusively linked to.  Furthermore I want the counter to be futher categorized by the financial quarter (1-4).  The way I hope this to work is that say that one day I get samples at 2 sites.  I input a new row.  In the Site Name column I input "Site A", and that the sample was collected in Quarter "2".  I create another new row for the other site that I sampled "Site B" also collected in quarter "2".  In this example Site A has already had 5 samples this quarter(2), and site B has had 2 samples in this quarter(2).  I want my counter to automatically populate a "6" for sample count for Site A, and "3" for Site B.  I then want to use this counter to populate a bar graph indicating the progression toward the 15 samples per Quarter goal for each site.  Help! ... View more

Out of the blue I have lost the ability to drag and drop into graph builder.  Any thoughts? Is there a toggle for this? ... View more