Hi ,
I have created a tableau calculation with If else statement to define various categories and below are the catgories i defined in the calculation Collaborations
'Chugai'
'pRED'
'CICor Projects'
Global Marketing & Medical Affairs'
Local Medical Affairs'
Business Enabling
License to Operate'
Productivity & Organizational Improvement'
Training & Education
Exploratory Research
Pioneer Sciences
Portfolio Enabling
Portfolio Other
ED
Pipeline Other
but some of the categories are not displaying due to other reasons like current phase and some other theme no are not existed in the data sources but i want to display all the categories mentioned in the formula as hard coded even if they have no data in the data source.
Ifyou see the screenshot ,only few of the categories are showing , not all the defined categoies in the formula and i want to display or hard code the defined categories in the formula even if they do not have data in teh data source.
How can achieve this in tableau , any one please advice. Thanks
#Tableau Desktop & Web Authoring
You could scaffold in all of your hard-coded values from a MS-excel worksheet:
Then join the above with your calculation for RC2 in the Data Source tab:
Left side is your RC2 calc, right side is the Excel worksheet Collaborations. Then in the actual worksheet of the workbook, you'll not use your RC2 calculation to display the rows, you'll use the new Collaborations (MS-excel) worksheet values instead:
Assuming you want to count those values from RC2, that is used in the Marks Card. As to why your results are null, well that's for you to correct. Please do not ask us to refine your calculation; our role is to supply you with the information you originally posted/requested. Attached is a mocked up workbook as we could not use your original workbook which is connected to Snowflake.
