Visualising data from different datasets in one visual

Question & Answer
, ,
1

Hi Community,

I want to create a sales dashboard that tracks my organizations sales vs budget. Caveat is that the sales data is pulling from a SQL database however the Budget data is from an excel file. How do I visualize these in one table?

2

@Andile You can’t tie multiple datasets with a single visual.
The workaround is to merge them.
e.g. add budget dataset to sales dataset. and then use the sales dataset for the visual.

image
image1621×470 64.2 KB

select dataset option

image
image1624×634 87 KB

select “sales” dataset

And then join them however you want.

3

I don’t have that “add data” button in the top right but but I want to create a dataset in the visuals so I don’t have to make infinite ocmbinations of all our tables as datasets. Does that make sense?