4 Replies Latest reply: Feb 14, 2016 6:49 PM by patrico mesri RSS

    Bart chart not showing bar after using in sheet filter that equals 0

    patrico mesri

      Hi community.

       

      I have a bar chart with the following Dimension with the calendar that shows each day of the week:

       

      Calendar:

      DECLARE FIELD DEFINITION TAGGED '$date'

      Parameters

      first_month_of_year = 1

      Fields

      Weekday($1) as Weekday Tagged '$weekday',

      DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric');

      DERIVE FIELDS FROM FIELDS "Fecha Registro" USING Calendar;

       

      and the Measure:

       

      Sum(Hours)

       

       

      I have a table next to the bar chart to be able to filter by each person how much hours have worked each day of the week (From Monday to Friday).

      When using the filter, you get that not everyone have worked everyday, so the bar chart starts moving.

      The problem is that I need the X axis (Day of the week) to not dissapear if that day is equal to 0.

      I tried Show Nulls and Zero Values but it doesn't do the job.

       

      Thank you in advance.

      Regards.