2 Replies Latest reply on Apr 20, 2018 5:22 AM by chirag kalra

    Excluding future months from the Line graph

    chirag kalra

      I have a calculate field as '# Inactive Customers'

      In the line graph, I am comparing 2017 and 2018 year. The problem is in the data, for entire 2018, we already have total number of customers around 15K per month.

      Now in the line graph for future months it shows them as Inactive and as the month approaches, the numbers keeps getting lower. But, I would like to show until current month for the current year and exclude all the future months. So the straight orange line is the problem which shows future months. 

      Calculation for '# Inactive customers': CountD(if [orders] = 0 then [customer ID] end)

      Screenshot attached below

      1.PNG

      Thank You for the inputs