4 Replies Latest reply: Jun 28, 2016 4:43 AM by Uday Pasupuleti RSS

    Show empty dates on chart

    Evgeny Stuchalkin

      Hello! I have measure with formula, that counts call outs:

       

      Count({$< [Тип события]={'CALL_OUT'}, [Тип разговора]={'Разговор состоялся'}>}DISTINCT [ID события])

       

      But weekends dates not displayng in the chart with 0 values (i'm using master calendar, so this dates exists)

       

      e1d0d3b059.jpg

      i know about method to write something like +sum({$<[Year]={"*"}>}0), but after it i can see on chart all dates of calendar, that can go far in to future:

       

      61d53fd4c7.jpg

      How to display on chart only dates, that no more than today and no less than 01.01.2015? My current formula is

       

      Count({$< [Тип события]={'CALL_OUT'}, [Тип разговора]={'Разговор состоялся'}>}DISTINCT [ID события])+sum({$<[Year]={"*"}>}0)