Profile picture for user knircky

I have a MashUp where I have daily records.

I.e. Date, #

I am displaying a line chart where I can see # for every day. 

I also want to display a bar chart where I can display # per week. I tried to accomplish this task by assigning my date axis with a different format "MMM YYYY" vs "DD. MMM YYYY HH". This however has no effect on the chart.

So is this possible to do or do I need aggregate the data somewhere else, i .e. in the data source.

How would I go about doing this providing I do not have access to the source data directly, i.e. cant change the original form of the data?

by Stephan Freudl
Posted on Mon, 10/26/2009 - 12:13

Hi Phil,

for exactly this purpose we invented the Feed Editor. It allows you to manipulate data which you don't own. Whenever its read, the same computation - say transformation - will be applied automatically and transparently.

As you indicate you want to aggregate, i.e. instead of a per day granularity a per month one. Changing the format in data assginment mode (within the composer) doesn't do this.

The operator "Convert date" does the job. It removes precision from each date value specified. Having values for each date in the beginning results in having 30 values per month. Now when assigning such data feed to a presentation component, say bar chart, select the proper aggregation strategy to handle values from the same month: Weighted average, sum and so on.

0
by Phil Knirck Author
Posted on Tue, 10/27/2009 - 18:47

Nice,

thank you that worked :-)  

0

Featured achievement

Genius
You like to help others solve their problems by answering questions.
Recent Unlocks
  • KF
  • KH
  • RG
  • Profile picture for user Vee_ARIS
  • Profile picture for user smarty
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock