14. Visuals and Their Formatting
14.17 Table
Shows detailed rows and exact numbers.
- Field wells: Columns.
- Example: Order ID, Order DateTime, Customer Name, Store Name, Amount, Delivery Time Mins, Order Status. It is used on a drill-through page (Module 17).
- Avoid as the main visual of an executive page.
- Formatting: Style presets (Minimal, Bold header, Alternating rows …), Grid (horizontal/vertical gridlines, row padding), Values (font, alternate background), Column headers (text wrap, alignment), Totals, Specific column (format one column), Cell elements (background/font colour, data bars, icons, web URL, Module 20), URL icon, Image size (for image URLs).
Ravindra Bagale's Tip
A common mistake is dumping a 50,000-row table visual on the overview page. Tables are for detail pages. Limit the rows with a Top N filter or drill-through, and apply conditional formatting so the important rows stand out. Practise, and it will feel very easy.
Ravindra Bagale's Tip – मराठी
एक common चूक म्हणजे overview page वर 50,000-row चा table visual टाकणं. Tables हे detail pages साठी असतात. Top N filter किंवा drill-through ने rows मर्यादित करा, आणि महत्त्वाच्या rows उठून दिसाव्यात म्हणून conditional formatting लावा. Practice करा, मग एकदम सोपं वाटेल.
Ravindra Bagale's Tip – हिंदी
एक common गलती है overview page पर 50,000-row का table visual डाल देना. Tables detail pages के लिए होती हैं. Top N filter या drill-through से rows सीमित करो, और ज़रूरी rows उभरकर दिखें इसलिए conditional formatting लगाओ. Practice करो, फिर बहुत आसान लगेगा.