I have a bar report to show the epic progress percentage complete custom measure. How can I create a filter to sort the percentage complete from 0% to 100% value?
Here is the epic progress percent complete definition for my report.
CASE WHEN
([Measures].[Hours spent] + [Measures].[Remaining estimated hours]) > 0
THEN
CoalesceEmpty(
[Measures].[Hours spent],0
) /
([Measures].[Hours spent] + [Measures].[Remaining estimated hours])
END
Hi @Aaron
Thank you for your question!
I recommend switching to the table view and ordering the particular measure by Ascending (learn more here - Create reports)
Once done so, this is how your report might look:
Best wishes,
Elita from support@eazybi.com
@Elita.Kalane - It is not very clear. Please suggest an easy way to have a Epic Progress report. The structure is: we have Epics, and under each Epic we can have multiple stories. So we want see the progress percentage of all Epics in one view.
Hi Elita,
It works now. Thanks so much.
An
1 Like