4 Replies Latest reply: Jun 24, 2016 7:48 AM by Shuhel Miah RSS

    Show empty values as zero in line chart with set analysis

    Shuhel Miah

      Hi,

       

      I have records with empty date entries like the following:

       

      DateCountActivity

      07/01/2016

      5View
      08/01/201610View
      08/01/20165Create
      10/01/20165View
      12/01/20162Create
      13/01/20166View

       

      I am using the following expression sum({<Activity={'View'}>}Count) to try and produce a line chart for view activity only, however it skips the intervening dates where rows with the value do not exist. It works interestingly when I remove the set analysis. I am using a master calendar.

       

      Any help appreciated.

       

      Thanks,

       

      Message was edited by: Shuhel Miah with new detail