I have created a progress_tracker to visualize the status of the project. The absolute numbers are correct and the chart looks fine. Now I want to do the same, displaying % values - e.g. for one area (x-axis), there are four reports, two of them are done, so that should be 50%.
Can anybody lend me a hand here? For some reason, the relative values are garbage.
You'll need to use the total keyword in your expression I think.
sum(Amount)/sum(total Amount) will calculate the % of the total over all dimensions of the chart.
If you need the percentage over a specific dimension(s) you'll need to include the dimension name(s) between < and > characters. For example sum(Amount)/sum(total <Product> Amount).
