9 Replies Latest reply on Jul 6, 2018 4:41 AM by Sonali Lohia

# % Graph

Hello Guys,

I hope all is well.

I have a measure that has 30,1 % as output if I select Canal =GCI and offer =M2M

here is my output : my expression % Réalisé : [Nbr] / ATTR([Target])

the requested output is this :

I need to display the rest of percentage 100 - 30,1 in the graphe

How to do this

Thanks

• ###### 1. Re: % Graph

Hi ,

If I understand correctly , you just want to show 31% and 100-31=69% both in one graph.

Instead of applying filter write if statement like If Canal ='GCI' and offer ='M2M' then 'Selected' else 'Others' end

• ###### 2. Re: % Graph

thanks Sonali you inderstand my request.

what's the version of your Tableau i can't open the file.

i did as you told me but i didn't get the % 100-30,1

Thanks

could you share the file in tableau Public

• ###### 3. Re: % Graph

My Tableau version is 2018.1

• ###### 4. Re: % Graph

Dear Sonali, export to him by Tableau Desktop for the version that him need.

• ###### 5. Re: % Graph

Dear Wiem, you need put the number of records twices in the rows and click in Dual Axis.

• ###### 6. Re: % Graph

Hi,

• ###### 7. Re: % Graph

Hello Guys,

I did as you mentionned, but the pb that I have more that two options in my case

I created a calculated field : GroupCGC

IF[Group Offre Cgc]='M2M'  and [Canal] ='GCI' then 'M2M' ELSE 'Others'

END

the % that i need to display in my graph are for M2M 30,5 and 69,5

i did a calculated field  but it didn't work

if ATTR([Group Offre Cgc]) ='VOIX'

THEN [Nbr] /

ATTR([Target])

ELSEIF ATTR([Group Offre Cgc]='Null') and ATTR([Group Offre Cgc]) ='VOIX' then (ATTR([Target])-[Nbr])/ATTR([Target])

END

I want to display them in the same graph pie chart

is that possible ?

Thanks

• ###### 8. Re: % Graph

Can you share the data in excel , as anyway you are sharing in image.

• ###### 9. Re: % Graph

Hi ,

I tried with some other way combining 2 axis - 1 is Pie and another is shape - Proportion.Attached is the workbook in 10.5 version