Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I want to show the legend with values in pie chart. Below i am attaching images
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
Ok, so in Expression tab you just need to uncheck "values on data points" in the expression with openings
In the presentation tab, check 'Show Numbers in Legend'
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])
Hello, Sudhakar!
Like this?
If so - just add to your dimension formula this part: Skillname &' - '& aggr(Count(Openings), Skillname)
HI Sergey Shuklin,
What you show in legend i want that output but i don't want those values in chart
Ok, so in Expression tab you just need to uncheck "values on data points" in the expression with openings
Hi Sergey Shuklin,
Thank you, I am checking all options except that.
Thank you very much for remembering that silly thing