Forum Discussion

rhcentennialh's avatar
rhcentennialh
Icon for Helper II rankHelper II
7 years ago
Solved

Max of Year - Visual Level Filter Selection

I am trying to find out how i can get the "Max of" selection back in my Visual Level Filters for a data referencing Years. I was able to accomplish this earlier in the year but cant remember how i did this.

 

 

 

 

Currently i am looking at this (Below) and am unable to recreate what i did at the beginning of the year. 

 

 

I need to make it be "Max of Encounter Date - Year" so my filter and visuals will work properly

 

Any help would be greatly appreciated

  • Hi rhcentennialh ,

     

    You may get this "Max of " setting like below in Format pane.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Given the images you have posted the Max of year is a calculated colunm or measure that is then being filtered the MAX included in the name can only be because you have a colunm called max of year.or a measure called max of year 

     

    i would guess that in one of your tables yeah have someting along the lines of Max of year = MAX([YEAR])

    would need to no exactly what your trying to achive and some sample data along with a model in order to help any further

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support

    Hi rhcentennialh ,

     

    You may get this "Max of " setting like below in Format pane.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.