4 Replies Latest reply: Mar 15, 2016 11:13 AM by Alex Timofeyev

# Drill value is not showing For Percentage in Bar Graph

Hi All,

I have bar graph . I created a Drill in that Tab and city..

First chart :

Dimension Drill:  TAB > City

Expression : Count(distinct{<Category= {'home_screen'},Action={'Scroll_to_tab'}>} VID)

and its working fine.. its show value correct for tab and for drill value for City ..

Second Chart :

Dimension Drill : TAB > City

Expression :

Count(distinct{<Category= {'home_screen'},Action={'Scroll_to_tab'},City=>} VID)

/

For Tab its shows a Correct Value but when i drill for City it shows Nothing....

Kinldy Check and help me with the same..

• ###### Re: Drill value is not showing For Percentage in Bar Graph

Try this for the second expression:

Count(distinct{<Category= {'home_screen'},Action={'Scroll_to_tab'},City=>} VID)

/

Is the result what you were looking for?

Alex

• ###### Re: Drill value is not showing For Percentage in Bar Graph

Hi

may be with this mesure : (addind dollar sign \$ )

Count(distinct \${<Category= {'home_screen'},Action={'Scroll_to_tab'},City=>} VID)

/

getting this bar chart :

and cities :

hope it helps

Bruno

• ###### Re: Drill value is not showing For Percentage in Bar Graph

Hi Bruno ,

It solve my Problem but not Entirely .

1. Because it Shows all Dimension and not based on condition..

2. and Percentage value as well shows different...

Kindly check and Help me

• ###### Re: Drill value is not showing For Percentage in Bar Graph

It is a selection problem, on you set analysis you are reducing the values when selected. I don't have sure of the number but you can control how it can be done using the \$, 1, total and all qualifiers.

Count(distinct{<Category= {'home_screen'},Action={'Scroll_to_tab'},City=>} VID)

/