2 of 2 people found this helpful
Is there any provision to format the structure of your data? What data source are you using.
If you're using excel source. Then connect you data with legacy connection and pivot the data. So that you can get the dates in one column with Creation/Deletion flag.
Once done then put a data source relative date filter on "Pivot field Values" to show only non-null values.
If you're using any system db like oracle, my sql then recommended do some data massage to get the pivot format at ETL level or you can use Custom SQL.
Let us know If you've any query.
Thank you Mahfooj Khan and @Dhruv Gupta
This was very helpful - I went to implement this solution and found that I could not pivot because I am using multiple data sources (with inconsistant column titles). Using the attached .twbx as an example, are you aple to produce the same graph looking at the entire data set for all IDs (A1-A17) how many were created & deleted per given day.
Just like the graph you showed Mahfooj, just using the two data sources.
Greatly appreciate your help.
PivotOnMultipleDataSources.twbx 15.8 KB