1. We created a data source containing job information with several filter in query designer. (Personal Information > Job Information
2. Then we created another data source without job information in query designer. (User information > Primary Goal Fields)
In the Story Report Page, would it be possible that whatever filters applied on our first data source will also be applied on the second data source?
Let's say we create a Numeric Point Chart with Blended data and we want to have this as formula:
(Count all employees on 2nd data source) / (Count all employees on 1st data source)
We are thinking that since 1st data source has filters (ex. Only active employees) the 2nd data source should be affected and should only have active employees since it is blended. But it seems not.
Please advise as we don't want to add job information and filters on our 2nd data source data source.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.