How to compare rows in a report

[amadese]

Hi,

Is is possible to do something like follows with Webi? I do not know if I have equally to update the universe...

Id	fname	lname	add	city	state	zip
1	ABC	test 1	123 st	York	FL	21025
2	ABC	test 2	123 st	Penn	FL	21025

Given the above scenario, is it possible to compare items row by row and column by column and display only the things that have changed. For example

lname changed from 'test 1' to 'test 2', city changed from 'York' to 'Penn'.

Display a label 'lname changed from 'test 1' to 'test 2' on lname field, display a label 'city changed from 'York' to 'Penn'.

Can this be done ?

Many thanks in advance for your help

Regards,

[tanveer1 · Accepted solution]

Hi,

Create formula as below

= if ([lname] <> previous[lnmae]) then "lname changed from " + previous[lname] +"  to " + [lname]

Similarly for city also

Thanks,

Tanveer.

[amadese · Accepted solution]

Hi Tanveer,

Thanks for your reply,

In fact I have a linked table (linked_activity) with another table (activity). The link is done thanks to the user id and the activity id.

Table activity

Activity ID	Title	Cost
1	Activity Title 1	1000
2	Activity Title 2	500

Table linked_activity

ID	User Id	Activity id
1	1	1
2	1	2
3	2	2

I have equally history tables for all 3 tables (with same information and other fields as date, user and action as 'create', 'update' or 'delete').

- If an update is done on a user, a new line is added to the user_history table.

- If an update is done on an activity or on the link, the relating table is updated and a new line is added to the user_history table of the database.

In my universe I have all these information and I can display each line from the history table for the user.

But I would like to have the list of person with the changes done (either on the user details as done above or if no change has been done on the user details, I would like to see if the activities have been changed (link or activity details)

For example:

Person	Updates
1	lname city
2	Activity	1 (cost) 2 (title)
3	no

Could you please help me to do that?

Thanks in advance for your reply

[amadese · Accepted solution]

Nobody can help me to do this kind of report?

[tanveer1 · Accepted solution]

Hi Sebastien,

Is it not the same issue posted as

Is it not solved yet ? it says as answered though !

Thanks,

Tanveer.

[amadese · Accepted solution]

Hi Tansveer,

Your formula is useful and is working, It's ok for this topic even if I can not create the report as wanted.

For the other topic it still concerns for this kind of report, but under another layout, and the solution given is hepfull but I have not solved my final problem.

Regards