Tested in latest Safari, Chrome and Firefox on Mac OS, and IE11 on Windows.

What are the steps to reproduce this? I couldn't reproduce it. Are you using any custom plugins?

@mattab could you reproduce it?

@tsteur Here are the steps to reproduce:

1. Go to Piwik dashboard
2. Open the Actions menu
3. Open the Events report
4. Click on Event Actions in the Top Events link list
5. Observe first error message (see screen shot 1)
6. Click on the cog wheel in the top right corner to go to Administration
7. Observe second error message (see screen shot 2)

Thx. I can reproduce it with these steps: #9667

Tried to fix it but currently couldn't find a way to do it. Need to have a more detailed look some day later

How can i escape this bug to view normal events, i cannot view events when this bug occur

If you can, try to switch to another visualization. Or create a new user and view the reports with this user.

@phoob @hoang89 did it work to switch to another visualization?

Can you please describe how you mean I should do to switch to another visualization? As you can in my attached screen shot above (the first one) there is just an error message – no data table where I can choose another visualization.

I just realize this is not possible there as you are seeing this all the time. In my case, when I reproduced it, I was still able to change the visualization.

Can you maybe try to execute a query on the DB:

delete from piwik_option where option_name like "viewDataTableParameters_$YOUR_PIWIK_USERNAME_Events.%";
-- for example when username is "root"
delete from piwik_option where option_name like "viewDataTableParameters_root_Events.%";

Awesome! Deleting the options from piwik_option solved the issue for me.

FYI Added a FAQ to document how to reset the report settings: How do I reset the visualisations settings stored for a specific user, or for all users?

Hopefully this issue is fixed in 2.16.1-b3 (Learn more: http://piwik.org/faq/how-to-update/faq_159/ ). I'm closing now but if you experience this issue and are already using > 2.16.1-b3 please leave a comment asking to re-open this issue.

Just for the sake of it, I ran into that same issue recently with Matomo 3.3.0.
Had to issue the SQL DELETE command to overcome the issue.

Here is one scenario where this happens (and can be reproduced):

• I have the Event Widget on my Dashboard (it works fine)
• I go to the Event report page, and request a pivoted View from the Category table (it does the job alright)
• I go back to the Dahsboard --> Event Widget displays the following error message:

Unsupported pivot: the subtable dimension for 'Events.Noms d'évènement' does not match the requested pivotBy dimension. [subtable dimension = Events.EventAction, pivot by dimension = Events.EventCategory]

• Same issue, if I then go back to the Event page.

Not a big deal in my case (tiny personal web site), but there you go.

Thanks.

This issue (or a similar issue) was again experienced recently on the Cloud and it will be great to find the root cause and solution to prevent this from happening again. Unfortunately we don't know the exact steps to reproduce but the error message was: "Unsupported pivot: the subtable dimension for 'Events.getCategory' does not match the requested pivotBy dimension. [subtable dimension = Events.EventAction, pivot by dimension = Events.EventName]"

I found a way to reproduce:

• Go to any Events report
• switch to the alternate dimension in report footer
• switch to pivoted view of the report
• go back to the original dimension of the report

--> this will result in a similar error as above

The error is caused by this:
When switching to the pivoted view, Matomo will automatically store the viewDataTable settings for this report. This means a pivotBy value will be stored. When switching back to the other Dimension, that stored value is being reused, but doesn't match the subtable anymore, causing the mentioned error.