Ravindra BagaleCourses & study guides मराठी Track your progress

21. Dynamic Charts: Field Parameters, What-if and Dynamic Top N

By Last updated:

Ekach chart madhe user la Sales, Orders kiwa AOV nivadta aala tar? Kiwa City aivaji Category? Ya module madhe field parameters (बदलता येणारे मूल्य, जे अनेक ठिकाणी वापरता येते), jundi SWITCH method, what-if parameters aani dynamic Top N he sagla baghu.

What you will learn in this module

  • Field parameters to switch measures and to switch dimensions (dynamic axis)
  • The older method: a disconnected table + SWITCH measure
  • What-if (numeric range) parameters for scenarios
  • Dynamic Top N with a parameter
  • Chart/table toggle with bookmarks (recap)

Live story: Let the manager choose the measure

Suppose the Swiggy city lead wants one chart, but sometimes by Sales, sometimes by Orders, sometimes by AOV. She also wants Top 5 or Top 10 stores with a slider. This chapter uses field parameters, What-if parameters and dynamic Top N.

All numbers in this story are fictional practice data.

Concepts in this chapter

  1. 21.1Field Parameters: Switch Measures
  2. 21.2Field Parameters: Switch Dimensions (Dynamic Axis)
  3. 21.3The Older Method: Disconnected Table + SWITCH
  4. 21.4What-if Parameters (Numeric Range)
  5. 21.5Dynamic Top N with a Parameter
  6. 21.6Chart/Table Toggle (Recap)
  7. 21.7Calculation Groups and Time Intelligence Items
  8. 21.8Field Parameters or a Calculation Group

Review and practice

  1. ★Practice and Answer Key: Parameters and Top N

The chapter recap is at the end of the last concept page.

Ravi Sir's Cards: 11 revision, interview and comparison cards for this chapter · मराठी cards