21. Dynamic Charts: Field Parameters, What-if and Dynamic Top N
21.6 Chart/Table Toggle (Recap)
A classic dynamic-chart pattern is two visuals in the same place, shown/hidden with bookmarks and buttons. Module 19.4 has the full steps. Combine it with field parameters: the chart and the table both use Metric Selector, so one slicer drives both views.
Practice task
He bagha: build a "Dynamic Explorer" page: a Metric Selector (Sales, Orders, AOV, Avg Delivery), an Axis Selector (City, Category, Payment Mode, Order Hour), a Top N slider for the bar chart, a what-if slider for Target Delivery Minutes with % Orders Under Target, and a chart/table toggle. Add a dynamic title that names the metric and axis chosen.
Ravindra Bagale's Tip
Friends, many students keep both the chart and the table visible behind each other, which slows the page because both still run queries. Hidden visuals don't run queries, so make sure the bookmark actually hides one of them. Never forget this.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students chart आणि table दोन्ही एकमेकांच्या मागे visible ठेवतात, त्यामुळे page slow होतं कारण दोन्ही queries चालवतच राहतात. Hidden visuals queries चालवत नाहीत, म्हणून bookmark त्यातला एक खरंच hide करतो याची खात्री करा. हे अजिबात विसरू नका.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students chart और table दोनों को एक-दूसरे के पीछे visible रखते हैं, जिससे page slow होता है क्योंकि दोनों queries चलाते रहते हैं. Hidden visuals queries नहीं चलाते, इसलिए पक्का करो कि bookmark सच में उनमें से एक को hide करे. यह बिल्कुल मत भूलना.
Thodkyaat sangaycha tar (quick recap)
Measures badlayla field parameter, scenarios sathi what-if, aani Top N sathi RANKX kiwa Top N filter. Single select vapra aani sort check kara. Aata pudhe jaauya filters aani slicers kade.