Chart macro shows incorrect sort

[Vamshi Korde]

You'll notice in the above chart macro that the sorting is incorrect. Tried every option to fix it by making sure that there are no additional spaces etc.. nothing helped. Is this a known issue?

[Katerina Rudkovskaya_Stiltsoft_]

Hello @Vamshi Korde,

Please wrap your source table with the Table Filter macro, then open its macro browser and apply 'Default sorting':



Thus, you get filtered data in your chart:

Katerina
Stiltsoft

[Vamshi Korde]

[Vamshi Korde]

As you notice in the screenshots posted.

Pic 1-

I have chart from table macro - inside that I have table excerpt.

Pic2 -

I edited the table filter macro to sort by Period column but it didn't help anything on the chart.

Infact the table should be sorted by serial number for me (first column).

[Katerina Rudkovskaya_Stiltsoft_]

You need to wrap Table Excerpt Include with Table Filter and apply sorting for the 'Period' column.



Regarding your manually created table inside the Table Excerpt macro, you can also sort it with the help of Table Filter. Please choose the 'NO' column in its browser.
Please note that it doesn't influence your chart.

Katerina
Stiltsoft

[Vamshi Korde]

Still no luck, when I save the page. The sorting is still incorrect.

[Katerina Rudkovskaya_Stiltsoft_]

That's strange, please raise a support ticket (attach the screenshots and the Page Storage Format: Upper right corner of the page -> ... -> View Storage Format).

Thanks!

Katerina
Stiltsoft