Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Listing & Aligning data using many datasets
Migrateduser
I'm trying to display several columns of data where each column comes from a different data set. Basically I want it to list all Group Names along with their counts in each column.
Each dataset contains a Group & Count column and I have about 4-5 dataset in total. To start, I tried creating a Joint Dataset between two of the datasets using a full join on Group to see if that might get me what I want. But after doing that I have two output columns for Group and I need them in one so that one list of Groups will list out.
For example...
If the joint dataset columns are: DatasetA_Group, DatasetA_AcctsCreated, DatasetB_Group, DatasetB_AcctsDeleted
How can I display one group list (combine DatasetA_Group & DatasetB_Group) and then get the Accts Created and Accts Deleted values to align to the applicable group?
Also, when adding additional datasets to display with this output, do I just created a new joint dataset with the current one to get a new column added (i.e. accts updated)?
I'm confused.
Find more posts tagged with
Comments
There are no comments yet