Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
See the attached qvw.
Regards,
Fernando V.
Hi Fernando,
Its working as expected. Thanks.