Didn't get the supplier count on barchart

[SrinithiS]

I need to find out the supplier who didn't run the request based on the total suppliers - suppliers who run the request and flag should be yes. The below code works in KPI but its not showing the result in bar chart when the dimension is year.

Count({<[flag]={'Yes'}>} Distinct [Supplier Id])-count({<[Supplier Id]={"=count([requestId])>0"}, [flag]={'Yes'}>} Distinct [Supplier Id])

[Sayed_Mannan]

try this,

Count({<[flag]={'Yes'}, Year>} Distinct [Supplier Id]) - Count({<[Supplier Id]={"=Count([requestId])>0"}, [flag]={'Yes'}, Year>} Distinct [Supplier Id])