14. Visuals and Their Formatting
14.22 Small Multiples and Visual Calculations (Quick Look)
- Small multiples: drag City into the Small multiples well of a line or column chart to get one mini chart per city (Pune, Solapur, Nashik, Sambhaji Nagar, Kolhapur, Nagpur) with shared axes. Format with Visual › Small multiples (layout rows/columns, titles, borders).
- Visual calculations: select a visual › Home › New visual calculation to write a calculation that uses only the visual's data, e.g.
Running Orders = RUNNINGSUM([Total Orders]). They are good for simple running totals and percent-of-total without adding measures to the model.
Ravindra Bagale's Tip
Friends, many students create six copies of the same chart, one per city, instead of using small multiples. Put City in the Small multiples well so all charts share axes and formatting. Keep the number of panels small enough to stay readable. Remember this rule.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students small multiples वापरण्याऐवजी एकाच chart च्या सहा copies बनवतात, प्रत्येक city साठी एक. City ला Small multiples well मध्ये टाका, म्हणजे सगळे charts सारखे axes आणि formatting वापरतील. Panels ची संख्या वाचता येईल इतकी कमी ठेवा. हा नियम लक्षात ठेवा.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students small multiples की जगह एक ही chart की छह copies बनाते हैं, हर city के लिए एक. City को Small multiples well में डालो ताकि सभी charts एक जैसे axes और formatting इस्तेमाल करें. Panels की संख्या इतनी कम रखो कि पढ़ने में आसानी रहे. यह नियम याद रखो.