6 Replies Latest reply on Feb 17, 2016 3:03 AM by Mark Fraser

    Divide a value between months

    Márcio Sousa

      Given I have a number attribute, and two dates which comprise an interval, how do I make it so that I can show the number split between each month (depending how many days there are in the month)?

       

      Ex: Number = 55, Date1 = 5-15-2014, Date Date2 = 2-7-2014

      The end result would be shown in a bar chart with the values split in 3 months:

      May: 55 / 17 (17 being the number of days in may)

      June: 55 / 30

      July: 55 / 2