Forum Discussion

danszczepanski's avatar
danszczepanski
New Contributor II
4 months ago

BI Designer

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's avatar
    pranav46
    Contributor II

    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's avatar
      danszczepanski
      New Contributor II

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