Is it possible to add a calculated measure to chart?
I am fairly new to Design Studio and currently working on a version 1.5.
I have requirement where I need to use 2 Bex queries (different BW info providers) as data source for my application and consume the data coming from two data sources into two waterfall charts. This start is fine. However, now I need to create a measure dynamically which would be the difference of a measure available in both the Bex queries. eg. Net Sales. This measure must be included into one of the chart as well.
At the moment, I see that there is no possibility to merge data sources, and also the chart component only accepts Data source for binding.
I searched through SCN for any help from existing content and there is explained for possibility to create custom data sources using SDK, but at this moment I am not allowed to use SDK.And I did not come across any posts which suggest a similar possibility using the normal features.
I am able to derive the calculated measure, but I am stuck at how to include this into the chart. Is this even possible?