We have trouble to use the pivotby function with the provided example I found online:
as it is specific for events but we need a different dimensions as e.g. in follwing reporting structure we used with google analytics and want to use also now with matomo:
array_get(“goal(n)Completions”, 1)AS goal6Completions, -> a defined goal
Can you please provide a link as for the event example?