Transform Table Peek() and Previous() Help........

[prees959]

Hi,

Im trying to transform a table from  :

ID	TimeStamp	Page
76339	09/10/2018 15:34:44	Costs
76339	09/10/2018 15:34:57	Leads
76339	09/10/2018 15:40:35	Customers
76339	09/10/2018 15:44:28	Costs
76339	09/10/2018 15:44:34	Leads
76339	09/10/2018 15:45:15	Customers

To show the flow of pages accessed as :

ID	Page1	Page2	Page3	Page4	Page5	Page6
76339	Costs	Leads	Customers	Costs	Leads	Customers

... and so on.  

There may be far more page selections per ID but can would the code be able to dynamically create the required output regardless of the Pages?

Also, the table is ordered by ID and Timestamp when loaded.

many thanks and any help is greatly appreciated.

Phil

[marcus_sommer]

You could try to adapt a generic load approach for it whereby your page-values aren't unique in regard to the ID so that you may need to create an extra counter-field for it.

I don't know your requirement but I think I would rather use just an aggregation like:

concat(Page, ' ==> ', TimeStamp)

which will show the evolution within a single field respectively UI expression.

- Marcus

[prees959]

Hi @marcus_sommer 

Thanks for your reply.  I'm not sure I understand your solution.

I'm hoping to create a table from my main resident table with ID as the Key field in the format I've described.  I will be able to use these Page fields as Dimensions that can be selected for further analysis.

Many thanks,

Phil