0

chart list for development months

hi

 

I have a chart which is showing months 1 to 60+, i was wondering if its possible to show 1 to 24 then from there going in multiples of 3? so 27 30 33 etc...?

4 replies

null
    • imbarmarinescubar_pyram
    • 2 yrs ago
    • Reported - view

    Hi Nicholas Campbell ,

    Interesting question.
    I have an idea using a custom list:

    range(1, 24)
    +
    filter(range(27, end), caption is divisible by 3)

    in PQL it should look something like this:

    {
        range([Date].[Week Number].[1], [Date].[Week Number].[24])
        ,
        filter(
            range([Date].[Week Number].[27], [Date].[Week Number].[60]),
            number([Date].[Week Number].caption) % 3 == 0)
    }

    Imbar

    • Nicholas_Campbell
    • 2 yrs ago
    • Reported - view

    Hi

     

    Sorry I should have stated so its not a week number as such its a development month so in the data its just 1,2,3,4,5 etc with no time intelligence, 

     

    Thanks for the prompt response though :) much appreciated.

      • imbarmarinescubar_pyram
      • 2 yrs ago
      • Reported - view

      Nicholas Campbell 

      I used weeks as an example to test on a sample data set.
      As long as the column values are digits it should work the same.
      If the column isn't numeric then you can try to use any other manipulations needed on the caption inside the filter expression (substrings, casting etc).

    • Nicholas_Campbell
    • 2 yrs ago
    • Reported - view

    hero it works!!! thanks much appreciated :)

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 4Replies
  • 30Views
  • 2 Following