tag:blogger.com,1999:blog-3998628784041768080.post5078451414628665402..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Tableau Tip: Displaying multiple, disparate measures on multiple rowsVizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-3998628784041768080.post-48114051629350085622016-04-23T13:38:26.253+01:002016-04-23T13:38:26.253+01:00Gautam, just put the dimension you want to split u...Gautam, just put the dimension you want to split up your measure by on the color shelf.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-37894461665796481062016-04-22T19:46:22.974+01:002016-04-22T19:46:22.974+01:00Hi Andy,
I have a similar request but instead of ...Hi Andy,<br /><br />I have a similar request but instead of measures, how can we do this with dimensions.<br />How can you show the breakdown of a measure by different demographic dimensions, without drilldown.<br />It would great if you could point me to an example.<br /><br />GAnonymoushttps://www.blogger.com/profile/06487084558185963392noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-30262249287719584212014-07-04T17:42:43.440+01:002014-07-04T17:42:43.440+01:00See if this workbook does the trick for you. http...See if this workbook does the trick for you. https://dl.dropboxusercontent.com/u/14050515/VizWiz/Bar%20%28Actuals%29%20and%20Line%20%28Budget%29.twbx<br /><br />Note that this was built with Tableau 8.2 so you will need to have that version. If you have 8.1, let me know.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-40431103342701379392014-07-04T00:14:33.969+01:002014-07-04T00:14:33.969+01:00Hi, Looks like responses on this blog appears in d...Hi, Looks like responses on this blog appears in delay. The data is not from a Cube, it can be an excel too. I am not sure how to attach a workbook here and I see no option.<br /><br />The data below would help create a Bar (Actuals) and Line (Budget) chart in a visual with a dual option so that the Line chart go over the Bars:<br /><br />Fields Actuals Budgets<br />siri 90 100<br /Anonymoushttps://www.blogger.com/profile/15610502082162285749noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-4402292527212961872014-07-03T22:20:31.546+01:002014-07-03T22:20:31.546+01:00If you have two distinct measures (Actual and Budg...If you have two distinct measures (Actual and Budget), then you should be able to create a calculated field that compares the two. Are you working with a cube or something? If you post a sample workbook, I can help you out.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-52988788255914036022014-07-03T04:44:38.136+01:002014-07-03T04:44:38.136+01:00Thanks for response. This is relevant visual sinc...Thanks for response. This is relevant visual since I want to know which Bars have short fall over a period of time against set targets. The minus calc. field will not give desired result. I can give my fresh thoughts over example:<br /><br />We have Period (date fields), Budgets and Actuals in this example, we can build simple Bar and Line chart combination visual. Now, we will see some Bars Anonymoushttps://www.blogger.com/profile/15610502082162285749noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-58277509376821461132014-07-03T04:17:15.372+01:002014-07-03T04:17:15.372+01:00I wouldn't recommend this approach since you&#...I wouldn't recommend this approach since you're not comparing the same metric. You might be misleading your viewers. <br /><br />If you insist though, you can so it thorough a simple calculated field that is one measure minus the other than place it on the color shelf for the bars. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-72194842564277280292014-07-03T03:01:15.263+01:002014-07-03T03:01:15.263+01:00say when the Lines intersect with the Bars, then t...say when the Lines intersect with the Bars, then the Bars should change their color, and when the Lines passes above the Bars, the colors of the bars shouldn't change. Something like this will do. Hope I could clarify my question.Anonymoushttps://www.blogger.com/profile/15610502082162285749noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-31488241933261930172014-07-03T02:56:30.760+01:002014-07-03T02:56:30.760+01:00What do you mean by "when the bars are throug...What do you mean by "when the bars are through"?VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-22158490442167128912014-07-03T02:24:41.117+01:002014-07-03T02:24:41.117+01:00Hi, I have a combined charts visual (Lines on top ...Hi, I have a combined charts visual (Lines on top of Bar chart), now, I want to have the Bars change their colors to Red from Green when the Lines are through. Say the measures for Lines are Profits while the Bars rep. the Turnover. If you have any advise, appreciate it.<br /><br />I will try to keep active this sheet to check for updates, however, I wish if anyone of you writes copies me on myAnonymoushttps://www.blogger.com/profile/15610502082162285749noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-58408773658035340402013-08-29T13:33:30.053+01:002013-08-29T13:33:30.053+01:00..solved.. because I had a YEAR colour break alrea.....solved.. because I had a YEAR colour break already assignedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-86403466522246459752013-08-29T13:27:52.232+01:002013-08-29T13:27:52.232+01:00hmm, weird, I can only get the effect of (3) to wo...hmm, weird, I can only get the effect of (3) to work as documented here if I use a dual axis by dropping the new measure over to the right, then synchronize - if I try your way I get a split side by side line chartAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-76654426540856434422013-07-25T22:13:11.311+01:002013-07-25T22:13:11.311+01:00Thanks Joe!Thanks Joe!VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-50626061264280795902013-07-25T21:57:13.497+01:002013-07-25T21:57:13.497+01:00(For some reason my comment was removed, trying ag...(For some reason my comment was removed, trying again):<br /><br />Here is an another:<br />http://public.tableausoftware.com/views/examplescafoldunpivot/ResultJoe Makohttps://www.blogger.com/profile/15643500270169278424noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-11503307841497639652013-05-31T21:26:08.948+01:002013-05-31T21:26:08.948+01:00Well done Tom!Well done Tom!VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-932073282710316642013-05-25T13:49:30.284+01:002013-05-25T13:49:30.284+01:00Challenge accepted, on the #2 point. My solution:...Challenge accepted, on the #2 point. My solution:<br /><br />http://goo.gl/Dptez<br /><br />Let me know if this works for you :)Tom Dewarhttp://www.tomdewar.co.uknoreply@blogger.com