I am trying to find the windows_Sum ( Count ( [No of Roses]),-11,0)
But I wanted to exclude the Nulls ( not zeros) in [No of Roses] filed.
P.S : Am calculating for last 12 months values.
Try this - WINDOW_SUM(COUNT(IFNULL( [No of Roses],0)),-11,0)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...