none
Combine rang between and rows between in the same partition RRS feed

  • שאלה

  • I need to run a partition between rows x and y and calculate the standard deviation there. The issue is that I have outliers within this period that I wish to filter.

    each measure is of type :

    STDEV(measure) OVER (PARTITION BY [Dimention A],[Dimension B],[Dimension Cl] ORDER BY Date ROWS BETWEEN
    64 PRECEDING and 5 PRECEDING)

    How Can I filter the values within this partition based on the values inside the partition?

    יום שלישי 02 פברואר 2021 12:53

כל התגובות

  • Welcome to the MSDN Hebrew Data Platform forums

    This forum is for discussion in Hebrew. 

    There is a different forum for English of you need.

    Can we answer your question in Hebrew?

    In any case, in order to help you we need to reproduce the scenario. Please provide queries to create your table and to insert sample data. In addition please describe the expected result according to the sample data

    Thanks and welcome to the forum


    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]

    יום רביעי 10 פברואר 2021 02:33
    מנחה דיון