Skip to main content

Hello Everyone,

How to bucket multiple measure columns in dataflow? All I need is the right syntax of bucketing measure fields by field name (not field values). or any other work around it.

I hope you can help with providing a faster and easy way to achieve this in DF, not in the recipe. 

I have over 950 measure fields in my dataset and looking for a better way to use all those in the dashboard and be able to filter them by adding a dimension column in DS which will be used in grouping and global filters.

Here is an example and details; 

  • Column A is the measure field label
  • Column B is the trimmed field label to use in DB
  • Column C is the Broad bucket field that needs to be added in DF " Dimension field" 
  • Column D  is the Narrow Bucket column needs to add in DF   "Dimension field"
0/9000