on 07-29-2015 6:57 AM
Consider this scenario.
I have two data sets one with actual data which is coming universe which is based on SQL Server, other is based on excel file which has target data.
Now I want to create a calculated measure target-actual.
So calculated measure is based on measure from different data sets.
IS this possible in Lumira?
If yes how can I do this, in create measure option in Lumira it just shows me measure from same dataset.
Thanks,
Dilkush
Hi,
you'll need to Merge the 2 datasets first, then with the resulting (joined/consolidated dataset) you'll be able to visualise both your measures
regards
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Merging, I don't know if possible or not. One thing which I think can solve it is extract both the datasets in Excel, apply vlookup to populate the values and make it into one sheet and then use Lumira to do analytics on it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.