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 hier...
Need Help
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

    • Asim's avatar
      Asim
      Helper I
      8 years ago

      Dear Anonymous

      I am using multiple tables to access the data, kindly provide your email address so that i could send the full file.

       

      I have created two measures to calculate output km/hr of the machine, these measures works very well at machine level but  when i use the hierarchy feature like capacity group on top of machines then system just provide average of output km/hr.

       

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

       

      Total Loading time = sumx(Eventlog,IF(Eventlog[Event]="production",Eventlog[Duration]+Eventlog[TK1]+Eventlog[TK2]+Eventlog[TK3]+Eventlog[TK4],Eventlog[TK1]+Eventlog[TK2]+Eventlog[TK3]+Eventlog[TK4]))