Question

how to generate histogram

  • 20 August 2017
  • 8 replies
  • 78 views
B

Pl. see data in attached Excel file. I am able to obtain the data ready to plot histogram as shown in the attached Excel file. The further steps to plot histogram is where I am stuck.

1 Attachment

8 replies

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @bey_atkins2009,

The transformer ChartGenerator is interessant in your case.

You can find the documentation Chart Generator.

Thanks,

Danilo

fmelizard
Rank
Userlevel 3
Badge +13
Hi @bey_atkins2009, are you wanting a graphical histogram or a summary table like you've shown in your Excel? Also, what format do you want to write the histogram to?
M
Badge +2

Hello @bey_atkins2009,

In addition to @danilo_inovacao good recomendation you can use the HTMLreportGenerator to generate and display your charts in an HTML page using FME Desktop.

Cheers.

Lyes

B
Hi @bey_atkins2009, are you wanting a graphical histogram or a summary table like you've shown in your Excel? Also, what format do you want to write the histogram to?
Hi TiaAtSafe, I am already able to generate the summary table that I have shown. I would like to generate a graphical histogram from that summary table data and save it as an image file (.png). Is it a problem that the X values are not numeric values in this case ?

 

 

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @bey_atkins2009, could you share us your Workspace template ( . fmwt ) ?

Thanks,

Danilo

B

Hi @bey_atkins2009, could you share us your Workspace template ( . fmwt ) ?

Thanks,

Danilo

Pl. find the data in .csv file and the FME file .fmw in the attached zip file

 

 

test.zip

 

 

 

 

fmelizard
Rank
Userlevel 3
Badge +13

Hi @bey_atkins2009, using the ChartGenerator like @danilo_inovacao suggested should give you the output you're after. I created the following using the transformer:

I set the Chart Type to Bar in order to label with your range values.

 

 

EDIT: The Data Attribute was set to Number and the Data Label Attribute to Range.

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @bey_atkins2009, using the ChartGenerator like @danilo_inovacao suggested should give you the output you're after. I created the following using the transformer:

I set the Chart Type to Bar in order to label with your range values.

 

 

EDIT: The Data Attribute was set to Number and the Data Label Attribute to Range.

Perfect @TiaAtSafe, good Job.

 

Reply


Community Stats

28,633
Posts
109,177
Replies
36,513
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.