ARIS MashZone data aggregation with Pivot Table

Ok, I want to give an update on my problem:

I created the pivot table and the time filter works great, but there's one mistake in it.

When I choose e.g. October 2010, just one user shows up (Areeporn), because it's the only row that contains the date field next to it. The other users do not show up in the diagram because they don't have a related date. 

As you can see, I tried to extract the date from the SO_YR_MONTH column and copied it into the column SO_DAY... but there's no way to copy it into every row.

Unfortunately, the pivot table in excel do not allow any copy operations within a pivot table. As long as each row does not contain a date, I can't use the time filter :-(

Hello,

an alternatively whay without using a pivot table is to aggregate data directly in mashzone with the aggregate operator.

As result you get a similar result table as you show  in your description above.

This feed can be assign to each composer component like chart or timefilter, how you can see aren't there empty rows.

I hope that answer you question correctly.

Best regards,

Bernd

Yes, unfortunately MashZone does not "continue" to fill empty cells with the last read row value. So I am afraid you need to adjust your Excel sheet a little further.