Madhuri, You might be knowing these two points..but just putting it here..
By default if there in no value..You will see NULL and if you want to replace it with 0 use ZN function.
You can create a set using IS Sold values and use it in your color shelf if you need it be a summarized value.
Let me know, if it helped you...
Thanks & Regards
If I apply ZN function on my "Summary" calculated field, I am still going to see two values for each year under "Summary" -- [Zero/ NumericalValue]
I would like to see one summarized total value for each each year. Would you be able to help with that
I guess my issue is with the way I did my "Summary" calculated field.
I have one question. When you are selecting week, the spark line (Area chart) is only having values for Null. Thats y you are seeing those Null values. It will definitely come,no matter what you do. I think you need to recheck your Calculation.
Otherwise hat you can do create a duplicate of Summary calculated Field and convert it into continuous and then Put it into Filter shelf and go to the last Tab -special-> Non null values
My Another Question is why the slope of graph is getting decreased even that the value is keep on increasing . This is what is "Running Total" Keep on increasing.
I have made some changes ,have a look and let me know your thoughts on this
Thanks for looking into this, instead of adding "Summary" to the filters shelf, I was able to remove NULLS from "Summary" field on the view by using LOOKUP(Summary) and adding it to the filter, however, I still couldn't combine the values for "Summary" and have a view with one filled area chart for each year after adding "Is Sold" dimension.