I added function ZN() to your formula for calculating TOTAL VISITORS PARAM like this:
ZN([Vistors per page Yield - category]*[Page Yield - categoty])+ZN([Vistors per page Yield - Product]*[Page Yield - product])+ZN([Vistors per page Yield - Top_nav]*[Page Yield - top_nav])+ZN([Vistors per page Yield - Unknown]*[Page Yield - unknown])
Now it seems it is working. In the sheet Visitors total test I added page_type to Color and now the bar shows every component of your index.
Take a look at the sheet Visitors total & page type to see the figures of every component of the index TOTAL VISITORS PARAM
Check out the attached workbook.
I hope this helps
Example1_RM.twbx.zip 46.9 KB
Thank you, Ramon. I did just the same and it worked. I mistakenly thought that Tableau treats nulls as 0
I'm glad that solution works.