7 Replies Latest reply: Oct 17, 2017 6:52 AM by Alazne Valcuende RSS

    Sow Gaps on Time Field

    Eric Vilarrasa Canadell

      Hello Everyone,

       

      I have some data about events that happen in several days. In my chart, in order to show graphically if they are close to each order I want show the days with 0 as value. To do it, I need to have at least the register of the dais without events. The point is that if I select one EventCode that is not in all the days, those days disappear.  For this i fond 2 solutions:

       

           1 - Use the "show all values" on the Day dimension.

       

           2 - Use a hidden expression with that omits the EventCode Field like, sum({<Event=>} 1)

       

      But i can not use any of this two options for the following reasons:

       

           1.1 - I have a whole Year of data, using this solution find the days with events starts to be complicated (obviously using the scroll bar)

       

           2.2 - The hidden expression works fine but if you have EventCode as a secondary dimension (to know which of the selected events is happening)  all the different events appear on the legend. Given that on my QV exists like 50 different events, the user needs to see only the selected ones.

       

      Here is a QV and Dummy data to test my problem.

        

      Data:

      LOAD *

      Inline [

      Day,EventCode

      1,1

      1,1

      1,2

      2,2

      8,1

      10,2

      ];

       

       

      Concatenate(Data)

      LOAD *

      Inline [ Day

      3

      4

      6

      7

      9

      11

      12

      13

      14

      15

      16

      ];

       

      Is there any other way that let me select the EventCode without having to see all the days and or having to see all the EventCodes on the legend?

       

      Pictures of What I see electing EventCode 2 and Days from 1 to 11:

       

      0: If I don't do anything:

       

      GapsOnDays_0.png

       

      1: Solution1

      GapsOnDays_1.png


      2: Solution2


      GapsOnDays_2.png



      I also add a QV with this data.