rob_marshall 
-
Re: How can I get the average of months for prior year?
@ManjunathKN Because LAG() without Strict or SemiStrict can go either forwards or backwards based on the parameter...Strict and SemiStrict only has to account for one direction.2 -
Re: How can I get the average of months for prior year?
@ShubhamCh They are the full calculation time in ms, to get the seconds, you divide by 1000. Here is the trick, I removed the formula, then pasted it back in...Then looked at splunk for that serial n…2 -
Re: Using a date range in a SUM
DeveloperCYT, Hang with me as this will be kind of a long post, but I did get it working. Data by Product and Date (real Time): Result: Module by Product entering a Date (day value) There are two way…3 -
Re: Best way to set current period (month/quarter/year)
@bskelly When you say you go into filters, and deselect certain months, are you doing that in a Time filter (checking/unchecking booleans) or are you doing it via the filter on the view on the module…3 -
Re: Circular References - CUMULATE
@roger.griffin1 , Take a look at the below and let me know if this works for you. Thanks, Rob3
