Hello,
I have data provided to me that I am trying to transform into a stacked area chart by time of arrival. The data set is similar to the following format:
| Name | Status | 1-Jan | 2-Jan | 3-Jan |
| John Smith | Approved | 1/1/2018 15:30 | | |
| Jane Doe | Pending Approval | 1/1/2018 16:30 | 1/2/2018 10:00 | |
| Mary Smith | Approved | | | 1/3/2018 9:00 |
My desired outcome is to have a stacked area chart with the Legend represented by the Status column and a continuous hierarchical time scale along the bottom that allows me to drill into each day and see a count of the arrivals by day or by hour depending on the level of drill.
The solution is not as simple as merging the columns because one row may have data in two different day columns.
I cannot modify the data source so I need to transform the data within the query editor or create a calculated field in some way.
I am comfortable with DAX expressions but this seems to be a little beyond my current skills. I have never written R-scripts before so if that is the right tool for this then I will need to do some studying up on that.
Any help you can provide would be greatly appreciated.
