Aggregating the data by different dimensions but putting them in single chart/ table
I am a part of company, where we get customer's applications to process. Now there are two dates here:
1. Date on which application was created (inflow)
2. Date on which application was processed (outflow)
I want to show a comparative analysis of both in a single trend chart, which will show two series- 1st for inflow, 2nd for outflow. So idea is to create a single generic Week/ month column & then show the two series according to their respective dates.
But this method will lead to huge data bloat up, creating several entries for each record. Also, my question is more around creating one reference date column for 2 different columns in one shot & eventually rolling them both up as per reference column.