I have a simple Average Resolution Days Tracking report where I am tracking the Average Resolution Days for Issues with P1-Stopper and P2-High priorities.
I trying to plot a fixed guideline for each of the Stopper and High priorities which is 14 and 42 days respectively. I have defined 2 calculated members, P1-Stopper Guideline and P2-High Guideline where I have only assigned the respective values 13 and 42 days.
[Measures].[P1-Stopper Guideline] = 13
However, when the plot is finally being done I see 2 guidelines getting created automatically and I can’t even manipulate the values of the automatically created guidelines.
It would be really great if someone can please point me if there is anything I am missing here.
Could you post your table view report here ? Just select “Table” from the header and post here.
Here is the table Ganesh,
You can write some MDX function to remove automatic guidelines created on each issue type. please use below code for guidelines,
WHEN [Issue Type].CurrentMember.Name MATCHES ‘P1-Stopper’
WHEN [Issue Type].CurrentMember.Name MATCHES ‘P2-High’
Like wise you can create for other issue types too. Hope it helps
Thank You for your response. I made some tweaks to the above code,
CASE WHEN [Priority].CurrentMember.Name = “P1-Stopper”
After this it returned empty values for automatically generated P1-Stopper P2-High values and the P2-High P1-Stopper values. On the suggestion of EazyBI support team I got rid of these empty values I used the Hide Empty Option and was able to get rid of the extra columns.
Appreciate your help
Awesome. I just handled the same “Hide empty” in mdx query. any how using default option will improve some performance also.
you are welcome.