Error: Summary internal build error:
I receive the following error in Monarch 13 when I include a date in a summary as a calendar month time interval and use CountSubtPct(*) as my measurement. The summary is meant to shown a trend of percentages by month, which is easy enough to do in excel but proving to be very different in DataWatch.
Error: Summary internal build error: Failed to convert parameter value from Int32 to a DateTime
Does anyone have any insight as to how I can get around this?
Here is the summary I am trying to achieve:
Month | Approved | Declined |
---|---|---|
January | 50% | 50% |
February | 60% | 40% |
March | 55% | 45% |
April | 65% | 35% |
May | 60% | 40% |
By the way, this summary works fine if I create a character field called Month that is derived from the original date value, however, it does not order the months correctly because they are recognized as text. All input is appreciated - thanks.