pie chart showing text

[soniasweety]

Hi all,

in my pie chart below it is showing " the data set contains zero or negative values"

expression used: =Count({<WeekNumber={$(=vThisWeek)}>}type)

variable:   =vThisWeek=Week(Today())

if I convert  pie to table I didn't see any negative or zero values !

what might b the reason?

[arvind_patil]

Hi Sony,

Kindly provide sample app then we will help you more corrective manner.

Thanks,

Arvind Patil

[shraddha_g]

Try

if(Count({<WeekNumber={$(=vThisWeek)}>}type))>0,Count({<WeekNumber={$(=vThisWeek)}>}type)

)

[afsarshaikh · Accepted solution]

In the Properties pane for the Pie Chart, set the Limitation = Exact Value and use >0

Then uncheck "Show others" checkbox

[soniasweety]

no luck,

its giving the chart is not displayed because it contains only undefined values.

[shraddha_g]

Can you share sample app?

[soniasweety]

thanks its working fine

[Anonymous]

Really nice solution, thank you!