Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

How to show the legend with values in pie chart

Hello Experts,

I want to show the legend with values in pie chart. Below i am attaching images

Capture1.JPG

For this out put i used  Dimension: Skillname

Expression1:=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Total No. of Openings])

Expression2:==Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Ageing in days])


But i want to show the openings also in legend


For example like this i want

.NET-1

Consulting-1


Can you guys help me for this



Thank you in advance



Regards,

B V S Sudhakar

1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

Ok, so in Expression tab you just need to uncheck "values on data points" in the expression with openings

View solution in original post

6 Replies
tresesco
MVP
MVP

In the presentation tab, check 'Show Numbers in Legend'

bvssudhakar
Creator III
Creator III
Author

Hi Tresesco,

I tried with that option already, In that case i don't want this expression values in chart because once see the chart it is showing both expression values but i don't want below mentioned expression values and i want those values in legend

Expression1:=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Total No. of Openings])

Sergey_Shuklin
Specialist
Specialist

Hello, Sudhakar!

Like this?

custom_legend.png

If so - just add to your dimension formula this part: Skillname &' - '& aggr(Count(Openings), Skillname)

bvssudhakar
Creator III
Creator III
Author

HI Sergey Shuklin,

What you show in legend i want that output but i don't want those values in chart

Sergey_Shuklin
Specialist
Specialist

Ok, so in Expression tab you just need to uncheck "values on data points" in the expression with openings

bvssudhakar
Creator III
Creator III
Author

Hi Sergey Shuklin,


Thank you, I am checking all options except that.


Thank you very much for remembering that silly thing