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?
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.
