5 Replies Latest reply: Feb 25, 2015 2:59 AM by Jyothish KC RSS

    A subset of measure

    Boris Chigirintsev

      Hi!

       

      In my project, there is a field with dates . I need to draw a graph using the last 14 days. Now I use a formula to build measurement : aggr (if (rank ([Date]) < 14 , [Date]), [Date]). This function works , but not quite as much as I would like. If you select multiple values in the filter Date, the graph is redrawn and it remains only the selected values . I want to show always exactly 14 values in this graph.

       

      How can I fix my code?

       

      Thank U!