I am using the following No-Sql query to create a path to be displayed via a Sankey.
create table public.less_test_ich_banking_final
distribute by hash (path) as
SELECT path, count(*) as count
FROM nPath (
PARTITION BY customer_identifier, sessionid
ORDER BY interaction_timestamp
interaction_type <> 'COMPLETE_APPLICATION' AS INTERACTION,
interaction_type = 'COMPLETE_APPLICATION' AS CONVERSION
accumulate (interaction_type OF ANY (INTERACTION, CONVERSION)) AS path
GROUP BY 1
ORDER BY 2 DESC
The data used in this is of ICH_BANKING_DIST which I have sessionized.
Where exactly lies the problem? Did you manage to follow the steps described in the user guide under "Creating a Visualization Table"? It shows the sql syntax for a sankey graph:
create table aster_lens.cart_abandonment distribute by hash(id) as
(select * FROM nPathViz(
ON aster_lens.npath_output_abandoned_shopping_order as input
partition by storeid
subtitle('Tracking order in which items added to cart')
The problem doesn't lies in the SQL but in the visualisation.
Are there any ways to improve the resulting sankey visualisation ?