I have 2 bar charts to show.. side by side. i cant use the srcollling and limit to certain value shown, because if i do so, i have to scroll the left barr then scroll th right bar as well.
i am thinking, can i create Next or Previous button , and set it to show 5 data each time, previous or next. but when i click on the button, both bar charts to should be affected as well.
No. Depending on what you're loading from, that might or might not assign the right Rank values. But what it will definitely do is connect Country with Rank in the data model, which we need to avoid. Once you've loaded the table(s) that have Country in them, do this, mirroring what I had in the example.
Show: LOAD recno() as Rank AUTOGENERATE fieldvaluecount('Country') ;
Or maybe it's more clear if we do it with two variables. See attached.
