Nopes, either will not work. When I am considering only snapshot pqm in column shelf my Complaint # is coming fine as expected, whereas my IB # goes off. And when I am only considering snapshot ib in column shelf my IB # comes fine and Complaint # goes off.
I can't consider either at a time. This will not give me expected result. In my original Dashbord, data blending is performed between 2 data source ( Pivotal green plum and oracle) . so, my snapshot IB (coming from Green plum) is linked to my Snapshot PQM ( coming from oracle)..
So, to increase the dashboard performance we have dumped the 2 database and created a view in data virtulization considering the key columns. Hence to achieve the original dashboard approach (data blending on snap shot IB and snap shot PQM) i need to perform the union of the two date fields ( i.e snap shot IB and Snap shot PQM).
I need to plot the line/bar chart in such a way that my snap shot Ib and snap shot PQM is union. Unfortunately, I am unable to achieve this.... Please assist me. or suggest me a way how can I do this.
So union would put the values from 2 files on top of eqch other . Are you looking for that. I am sorry i am bit unclear on your requirements can u explain a bit