Time dimensions: Aggregate data to weeks months etc.

Last activity on October 1, 2023 - 11:21 25.5k Views 2 Replies MashZone

Phil Knirck on October 23, 2009

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?

Notify Moderator

2 Replies

Stephan Freudl on October 26, 2009

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.

Like

Sign in
or register to reply.

Notify Moderator
Phil Knirck Author on October 27, 2009

Nice,

thank you that worked :-)

Like

Sign in
or register to reply.

Notify Moderator

Upcoming events

Thursday, June 12, 2025 - 09:00

ARIS Super User Group Meeting

ARIS Super User Group Meeting