Forum Discussion

Asim's avatar
Asim
Helper I
8 years ago

scatter chart data aggregation issue

Good Morning,

 

I have been facing issue while creating scatter chart in my report.

I created a scatter chart in my report and it was showing correct result with machines but when i created a hierarchy which include machines and their capacity group then the quantity produced appearing as an average instead of sum.

for example, I have extrusion as capacity group and there are three machines involve in this process.

the total output km/hr of this group is (9.83+30.35+31.19) = 71.37 km/hr but in the chart it just shows the average = 23.79

whereas by drilling down it shows the correct output of all 3 machines.

 

How i can get a total value of these three machines in the capacity group

Any solution to overcome this issue,

 

Best Regards

Asim

 

 

 

 

 

 

 

 

 

 

 

 

 

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    You should be able to change the aggregation type if you click the drop down arrow on the field. But tough to say without source data, formulas and such.

    • Asim's avatar
      Asim
      Helper I
      8 years ago

       

      Good Morning Greg_Deckler

      I am using below mentioned measure to calculate the output km/hour of each machine.

       

      Output Km/Hr =
      calculate (
      SUM(PL[Act. Quant. Prod.]),
      TREATAS(values(Eventlog[Machine]),PL[Machine])) / 1000 / ( [Total Loading time] / 60 )

       

      As this is measure, hence the dropdown list is not available in the field pane.

      Do I need to make some changes in measure.

       

      Please suggest!

       

      Regards

      Asim

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Asim,

        It seems that the measure re-calculates in different levels. Could you please share sample data of your table for us to test?

        Regards,
        Lydia