Question

How do i create a Pivot chart in FME similar to Excel

  • 25 October 2018
  • 1 reply
  • 5 views
T
Badge

Hello,

I am trying to create a Pivot chart using FME.

I have attached a spreadsheet which shows my raw data and the pivot chart which excel can easily produce. You'll see that I have a Date, Area and Exports column. I essentially want to group the dates into month/year format and then use the Area numbers as headers with the number of exports summed for each month and area. It is also important that where no data exists, the chart produced shows this with zero values.

How should I go about doing this?

Tom

1 Attachment

1 reply

virtualcitymatt
Rank
Userlevel 4
Badge +26

Heya, @tbarnard93

 

I did some playing around with the data and I think I have something which works pretty good. It looks a little complex but the most tricky thing really was making sure that all months were included in the result.

 

In addition you will have to expose the unique 'Areas' after the 'pivot'. There is a nice little 'import' wizard which you can use to populate the AttributeExposer to avoid typos (it's tricky to do this in a dynamic way).

 

Take a look at the workspace and see how you can fit it to you're data.

 

xlsxr2none.fmwt

Reply


Community Stats

28,724
Posts
109,519
Replies
36,564
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.