Skip to main content
Question

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

  • October 25, 2018
  • 1 reply
  • 59 views
T
Forum|alt.badge.img

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

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.

1 reply

virtualcitymatt
Celebrity
Forum|alt.badge.img+47
  • virtualcitymattCelebrity
  • Celebrity
  • 2000 replies
  • October 25, 2018

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

Community Stats

32,084
Posts
121,835
Replies
39,721
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.