Skip to main content
Question

how to generate histogram

  • August 20, 2017
  • 8 replies
  • 471 views

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

8 replies

danilo_fme
Celebrity
Forum|alt.badge.img+54
  • Celebrity
  • August 20, 2017

Hi @bey_atkins2009,

The transformer ChartGenerator is interessant in your case.

You can find the documentation Chart Generator.

Thanks,

Danilo


fmelizard
Safer
Forum|alt.badge.img+22
  • Safer
  • August 22, 2017
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?

mygis
Supporter
Forum|alt.badge.img+15
  • Supporter
  • August 23, 2017

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


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
Celebrity
Forum|alt.badge.img+54
  • Celebrity
  • August 23, 2017

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

Thanks,

Danilo


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
Safer
Forum|alt.badge.img+22
  • Safer
  • August 23, 2017

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
Celebrity
Forum|alt.badge.img+54
  • Celebrity
  • August 23, 2017

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.