BI Designer

[danszczepanski]

Hello,

Is there a simple way to apply multiple data sources into one BI Blend Dashboard Graph? For example, a bar graph that compares Actual sales to PY. 

I am running a SQL script to return data for my data adapters. I've added them as components to my BI Viewer, and can select one or the other under the "Data Source" drop down. I just can't manage to get both sets of data into one chart. I know this is feasible but think I am missing something.

Thanks!

[pranav46]

Are you calling business rule into your data adapter or SQL query. If you can call BR which has sql in it and pass parameters then I believe you could do it.

[danszczepanski]

I have not taken that approach- but I will test this idea and let you know if it worked. Thank you.