5 Replies Latest reply: Nov 5, 2018 12:44 PM by Dilip Ranjith RSS

    Get data for the last day in a month

    Dmitry Zolotarev

      Hello!

      Data sample:

       

      AU_date | Value

      01/01/18 |  80

      01/02/18 |  150

      .....

      01/31/18 |  100

      ....

      04/30/18 |  188

       

      I want to create a bar chart with the dimension Last day of a month and a values in these days.

       

      For example:

      Last_date  |   Value

      _____________________

      01/31/18   |    100

      02/28/18   |    180

      03/31/18   |    174

      04/30/18   |    188

       

      To solve this, I wrote expression:

      SUM({S}<AU_Date = {"$(=MonthEnd(AU_Date))"}>, Value)

       

      But, it does not work...

       

      Could you help?

       

      Thank you in advance!