8 Replies Latest reply on Mar 11, 2018 6:44 PM by Bradley Bell

    Can't get LOD to work

    Bradley Bell

      I'm having a frustrating time figuring out how to use an LOD.

      I have a list of weekly room reservations, all broken down into day and half-hour block.

      I use one LOD to show the number of rooms reserved in each block:

       

      { FIXED [Year], [Quarter], [Room], [Day Of Week Name], [30 Minute Interval] : MIN([Number of Records]) }

       

      I'm not sure I understand it 100%, but the numbers look right.

      Usage.png

      Now if I want to show the usage rate, for each time block, rather than just the number of rooms reserved, it seems like I would want something like:

       

      { FIXED [Room], [Day Of Week Name], [30 Minute Interval] : MIN([Number of Records]) }

      /

      { FIXED [Room] : MIN([Number of Records]) }

       

      But that doesn't help at all (same result). What am I doing wrong?

      Usage-Percent.png

       

      I'm using Tableau 10.4.3