4 Replies Latest reply on May 17, 2016 1:30 AM by Kevin Bould

    Dimensions and Measures

    Kevin Bould

      Sorry, I know there are a lot of versions of this question around, but I've looked at A LOT of them and cannot fathom an answer. I know what I am asking should be possible, but it seems that it isn't, which baffles me. Iam hoping you can help

       

      I have some hotel data, much like the below (it's client data, so I cannot post real data)

       

          

       

      I need to have a dimension that groups by number of stays, filterable by date.

       

      So my overall  (unfiltered) table would show:

       

       

      I'd ideally like to then be able to filter by date.

       

      ...

       

      However to get stays, I need to do a count(stay id) (or just count, as it's a URN) which then means I cannot use it as a dimension, even if I manually create bins. I ideally want the discrete number first (as a dimension), then to great groups based on these.

       

      It seems to me, this should be a fairly straightforward thing, but it really isn't proving that. Any help at all is very much appreciated

       

      Kev