Hi All - i am loading data whereby all records have a CREATED_MONTH derived as part of the load. e.g.
Date(Date#(CREATED_DATETIME,'YYYY-MM-DD hh.mm.ss'),'DD/MM/YYYY') AS CREATED_DATE,
MonthName(timestamp#(CREATED_DATETIME,'YYYY-MM-DD hh.mm.ss')) as CREATED_MONTH
I wish to create a line graph which shows 2 tracked measures e.g. USER_UD created each month and accumulated count of USER_IDs per month. obviously i can just do a count of user_ids based on created_month but how do i create a cumulative value.
Am not sure whether of the expression.
So it would look something like this.
Any help appreciated. Also I wasnt sure whether it was best to include as part of the load script to generate a new table or within the expression of the graph.