Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to create a 100% stacked bar chart, but eliminate the NULL values from the data set. I know I can deselect "Show Null Values" from the chart settings, but clicking on the graph still pulls in the nulls into the data set.
I'm using the following Expression:
Count(RecordID) / Count(TOTAL <[Agent Name]> RecordID)
Could you please post some sample data here..
if I am not wrong
u can try like this if(not isnull(<[Agent Name]) ,
Count(RecordID) / Count(TOTAL <[Agent Name]> RecordID))