Hi, I have been trying to create line chart showing a count of the number of items of a particular status on a given day. I have been using rangecount and rangesum to try to achieve this with no luck.
Basically, i have a set of items (Id) which have a StatusCode (could be either A, C, U F...) . The items could have a 'NULL' or '00:00:00' value for TDate and also have a date created (%_Date)
I would like to count the number of unique items (Id) with an F StatusCode which were created (%_Date) on the day with a NULL TDate, for the last 30 days only
I have been using the expressions as follows;
RangeCount (Above(Count(Distinct if(xxx.StatusCode='F'and IsNull(xxx.TDate), [xxx.Id])),0,rowno()))
I am currently having two issues depending on which calcs i use. Either the date values are now unique, thus i will have two or three of the same date with one item attributed to each, OR i the graph will display a correct incline BUT the first date will have a value of one where it should actually have a value of 40 and accumulate from there.
Any help would e greatly appreciated.