Calculate average time for aggregated attributes in Pie Chart

[#1]

Hello all,

I need to build a pie chart that shows the average time (in days and months) between a Start and  End Date for an aggregated set of status.

I’m trying to define the aggregation of Status values in the load script.

The attached file is a sample of what I’m trying to do and shows a pie chart that gives results, but without aggregation on Status attribute.

Could anyone help on this, please?

Many thanks

Paulo

[#2]

Hi Fernando,

Thanks. This is very close of what I'm looking for.

To avoid the inline table, imagine that I have a column with the Status Text in the data table. How can I aggregated them following the same logic, e.g. using a calculated dimension?

Thanks

Paulo

[Anonymous · Accepted solution]

Hi,

See the attached qvw.

Regards,

Fernando V.

[#4]

Hi Fernando,

Its working as expected. Thanks.