Trend line without dates

[Anonymous]

Hi everyone,

I need to generate a trend graphic in one of my dashboards, though, the dataset I am using doesn't have a "Date" column. The scenario is like this:

There is a list of employees who have a status of Authorized or not authorized that is updated from a web application. I currently show a percentage of the total employees who are authorized vs not authorized, but we need to see how this % changes through the months. The problem is that the dataset doesn't have a column that identifies the % for each month.

I tried creating a new table where the first column is the month of the year, and then calculate the second column to fix the value of the percentage of authorized employees to that date. The problem is that I don't know how to do that or even know if it's possible.

Any help would be of great value.

[parry2k]

@Anonymous not fully sure without having date it is possible but if you paste a sample data and expected output, might be there is a solution. 

[Anonymous]

@parry2kThanks for your answer. Unluckily the data has privacy protection, but it looks something like this:

What I expect is let's say this was the status on January 1st so I take this average as the average for January, then on February 1st I take that average as the average for February and so on, something like this:

Hope this makes it clear.

Thanks in advance.