Load KPI Targets from Separate Dataset

Question & Answer
1

I have a dataset that shows metric performance across various populations I would like to filter by. I have another dataset that shows static goal metrics. These don’t really make sense to join as a datasets, but I want to be able to drag the metric goals into the visual as targets.

Example Dataset 1
Region|Sales|Expenses
Region 1|$1M|$2M
Region 2|$2M|$3M

Metric Goal Dataset
Sales Target|$2M
Expense Target|$1.5M

1 Like
2

Hi @cactus : Is both of your data sets are belong to a relation db? If yes, can we use custom sql and create the data set. If you can also give some sample input and expected output in detail, it will help in guiding the solution.

Tagging @Ashok for expert advise as well.

Regards - Sanjeeb

2 Likes