1 Reply Latest reply on Dec 30, 2016 7:58 AM by Sagar Sanjay Joshi

    How to filter and display First N string values in an axis?

    Bagiyaraj Natarajan

      Hi,

       

      My X Axis has Work Week values as String (1-2016, 2-2016 and so on, its from a reference database) . I want to filter the last N values of this axis and display only those N values.  I cannot use LAST() function as it only works for integer (https://www.google.com.sg/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwjEoMLZyZvRAhVIwLwKHZ9sBn0QF… ). My field value is a "String". Is there a way to achieve this?

       

      Thanks,

      Bagi