I need a bit more clarification about issue #1 but issue number two has a couple of solutions. One solution would be to utilize a seperate view for just the Cross Sector and then place this either as a floating object or as another dashboard object in the view. To do this however, you will need to supply a table calculation on the view such as index() to prevent the rows that are blank from collapsing. Here I have done this with a floating object:
The attachment is v10 of Tableau but the method is outlined.
BMC Dashboard_v10.0 (Admin)_pv.twbx 867.2 KB
Thanks for your help.
It worked fine. As i also give a thought to make another view and take the cross sector field as floating in the dashboard but failed to represent the null values. For example, for APAC - FSO region we don't have values in cross sector so the blank values automatically collapsed. To avoid that i made a calculated field with this:
iif ( isnull(COUNTD([Program])),0,COUNTD([Program]))
but it didn't work and I don't know why. Anyway thanks a lot. It would be great if you can help me out in the issue no 1. So, i just wanted to show the programs and Initiatives in a same manner as represented in the slide. So, rather than taking distinct program it is showing the same programs with the different initiatives but as we used the AGG function in dashboard it is not possible in tableau because of the limitation. Is there any other method or tweak we can do with this dashboard would be great.
Let me know if you require any other details.
Thanks and Regards,
Did you try the index() table calc to manage the nulls as I did in the example? That should work to manage this issue.
I'll look at the other issue a bit more to see if I have any suggestions later today. Thank you for getting back and marking the post.
Yes, I tried the function Index() and it worked fine for me. Also, I replaced the null value to zero as i wanted. Thanks for your efforts. I really appreciate if you can figure out the issue of grouping the programs somehow.