Hello Vinutha, the option you mentioned did not helped, i am more looking at field value calculation, i would appreciate, if you can share a sample worksheet that you explained
i have tableau 9.0, if it is not a big ask can this be done in 9.0?
Appreciate your help
Hello Mahfooj, the issue is i am not able to open the file you provided due to version issue, therefore i requested for 9.0 version worksheet.
2 of 2 people found this helpful
Okay I'll share you the steps please follow the stpes and try to execute it. Let me know If you stuck anywhere.
First create three calculated measure using the screen shots
Once you done then create a dummy calc field like this which will be use in your viz
Now drag Dummy measure to columns shelf three times like this. And Cat at row shelf. You'll get below attached view.
Right click on axis and edit it
first change the title to "RLDQ Score"
Now go to the second tab (tick marks) and select none
you'll get this view. Repeat the edit axis steps for others like location and policy in rest of the dummy.
Once done you'll get this view
Now in the marks card go to all and select the chart type from automatic to text you'll get below view
Remove the zero line from the sheets. Right click and select format.
Now main part of the viz select the first dummy from marks card and drag the measure to lebel and KPI to color. Follow the screen shot and change the colors manually.
Repeat the steps for location in Sum(dummy)(2) and Policy in Sum(dummy)(3)
Once done then you're sheet will be like this
You might be thinking why headers are at bottom. For headers at top you've to right click on the active sheet and duplicate sheet.
Now go to the duplicated sheet and from the marks card just remove the measures
Now create another string calculated field called "Empty"
Now drag this to label in the marks card for "All"
Your view will be like this
Now create a new dashboard
Drag the first sheet as tiled remove the title of the sheet and fit with width. You've to drag the header sheet as floating fit the entire view hide the title and just put above the scores and ajust the grid manually.
Now the final view gonna be like this
I hope you can do this.
Don't forget to mark my answer as correct At least for my efforts of taking so many screen shots. All the best.
thank you so much truly appreciate your help. this is great.
Do you want the same KPIs for all these measures?
yes, please thats the requirement
In the same way you can easily achieve. Now you understand the trick.
If you stuck I'll help you definitely. Give a try.