3 Replies Latest reply on Apr 3, 2018 11:44 AM by Gilad Wilkenfeld

    Creating an event counter with sparse data (some dates missing)

    Gilad Wilkenfeld

      Hello all. I am wondering if someone can help me wrap my head around a problem I am having creating a visualization for a client. My client is looking for a simple line graph that displays the year along the X axis and a rolling count along the Y. Theoretically the line would either tick up one notch each day an event occurred, or remain flat on days when it didn't. The line would grow each day either up or flat throughout the year until a goal is reached. The problem I am having is the data are sparse, in this case missing dates. I have tried a few things, but admit this type of problem is a little bit out of my comfort zone. Has anyone else encountered this problem and can provide some advice?

       

      Thanks so much

       

      Gilad