1 Reply Latest reply: Nov 6, 2013 1:54 PM by Gysbert Wassenaar RSS

    Added/Dropped Accounts Based on Date

      Hello,

       

      I am having an issue creating a bar chart based on the requirements. Basically I have some data stacked on top of each other, and based on the dates, I need to count the accounts that added each month, the accounts that are dropped each month.

       

      I am getting stuck when I have to write an expression that compares the dates and look at whether the account exists or not in that month. I began using the Today function and the InMonth function but I realized that this will not work unless it is during an ideal situation where each month the data is loaded on the 30th.

       

      I have attached an excel file with some dummy data and a qvw file with the bar chart and the two expressions that need to be filled in the end (Added & Dropped)

       

      Any help would be greatly appreciated.