Comparing Datasets

building reports desktopintelligence
1

Hello Everyone

Thanks in advance for any help you may be able to provide in solving my query.

I’m using Deski and would like to compare a table of employees and highlight where changes have occurred.

I’ve built a query which looks at the employee structure for 30 days ago. I’ve used the same query to populate another table using the same query only this time it looks at yesterday’s employee structure. The results of both queries sit side by side on the same page.

I’ve then written a formula to compare both tables to determine if any emplyees have changed roles within the last 30 days

= If <Role(Query 2)><><Role(Query 1)> Then “Role Change” Else “-”

It all should be pretty straight forward but although the syntax of the formula seems to work I’m not getting any results from it, even though I can see examples of role changes in the 2nd query. Both queries have the following dimensions

Employee Name (dimension)
Employee Number (dimension)
Skill (dimension)
Role (dimension)
FTE (measure)

I’m doing something wrong, can anyone offer any suggestions please?

Avinit (BOB member since 2009-05-14)

2

How are you merging (relating) both the queries in your report?

vinod_menon :india: (BOB member since 2007-04-09)

3

They are not merged as such as they both come from the same data provider. I can’t see where I could link the two sets together by a common variable such as employee number

Employee Number is actually detail and not dimension as I said in my original post.

I’ve attempted to create a combined query and have created a table with 2 entries, 1 for each dataset but can’t work out how to compare each row (as I would do in Excel)

Thanks for your help

Avinit (BOB member since 2009-05-14)