Issue Regarding Guideline

Questions & Answers
,
1

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.

image
image.png1664×729 63.1 KB

It would be really great if someone can please point me if there is anything I am missing here.

2

Hello Arunava,

Could you post your table view report here ? Just select “Table” from the header and post here.

thanks

3

Here is the table Ganesh,

image
image.png966×368 18.2 KB

4

Hi Arunava,

You can write some MDX function to remove automatic guidelines created on each issue type. please use below code for guidelines,

P1-Stopper

CASE
WHEN [Issue Type].CurrentMember.Name MATCHES ‘P1-Stopper’
THEN
13
ELSE
NULL
END

P2-High

CASE
WHEN [Issue Type].CurrentMember.Name MATCHES ‘P2-High’
THEN
42
ELSE
NULL
END

Like wise you can create for other issue types too. Hope it helps

1 Like
5

Hi Ganesh,

Thank You for your response. I made some tweaks to the above code,

CASE WHEN [Priority].CurrentMember.Name = “P1-Stopper”
THEN 13
END

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 :slight_smile:

1 Like
6

Awesome. I just handled the same “Hide empty” in mdx query. any how using default option will improve some performance also.

you are welcome.