Forum Discussion

Salle's avatar
Salle
Icon for Advocate I rankAdvocate I
3 years ago

Group Measures as field parameters

New to using Field parameters - Is it possible to group field parameters?

Let say I have 3 products x 3 measures each I want to plot.
Product1

Measure1: Product 1 sales, Product 1 sales PY, Product 2, sales YTD
Product2:
Measure 1: Product 2 sales, Product 2 sales PY, Product 2 sales YTD
Product 3
Measure 1: Product 3 sales, Product 3 sales PY, Product 3 sales YTD.

I want to select only between "groups" Product 1 / Product 2 / Product 3 in a slicer tile which then shall dynamically change a combo bar/line chart on 3 different fields;
Y-axis (bar); sales
Y-axis (line1); sales PY
Y-axis (line2); sales YTD
X-axis (month)

 

Is the scenario above possible with field parameters feature?

Need Help

5 Replies

  • nirrobi's avatar
    nirrobi
    Icon for Helper V rankHelper V
    2 years ago

    There is 4 parameter in the field parameter that you can group measures inside the formula 

     

     

     

  • AGScottThompson's avatar
    AGScottThompson
    Frequent Visitor
    3 years ago

    Yes, Once you create your field parameter. Go to Table tools and select data groups and create your groups/

    • Salle's avatar
      Salle
      Icon for Advocate I rankAdvocate I
      3 years ago

      AGScottThompson Thanks for the reply.

      I was able to set it up (in Columns Tools > Data Groups) and got it working as either a line or bar chart (with the Field group as value and month on x-axis).

      But is it also possible to use it for a combo chart, I want to visualize the different measures as either line or bar as shown below? Or do I need to set up the groups differently e.g. two different field tables (one for the line measures and one for the bar measures in the combo chart)?

      Lets say I have 3 products x 3 measures each I want to plot.
      Product1

      Group1: Product 1 sales, Product 1 sales PY, Product 2, sales YTD
      Product2:
      Group 2: Product 2 sales, Product 2 sales PY, Product 2 sales YTD
      Product 3
      Group 3: Product 3 sales, Product 3 sales PY, Product 3 sales YTD.

      I want to select only between "groups" Product 1 / Product 2 / Product 3 in a slicer tile which then shall dynamically change a combo bar/line chart on 3 different fields;

      COMBO CHART 
      Y-axis (bar); sales (group 1-3 depending on selection)
      Y-axis (line1); sales PY (group 1-3 depending on selection)
      Y-axis (line2); sales YTD (group 1-3 depending on selection)
      X-axis (month) 

       

      • SumitPandey's avatar
        SumitPandey
        Frequent Visitor
        3 years ago

        How did you group in the field parameters?

        As I am not getting option to group it.

        Could you please provide some snapshots? Thanks!