tag:blogger.com,1999:blog-3998628784041768080.post7259403313382273576..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Tableau Tip: KPIs and Sparklines in the Same WorksheetVizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger57125tag:blogger.com,1999:blog-3998628784041768080.post-25267599608283829612017-09-29T12:00:40.350+01:002017-09-29T12:00:40.350+01:00Ask for help on the Forums.Ask for help on the Forums.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-9301469224134376162017-09-29T10:26:31.022+01:002017-09-29T10:26:31.022+01:00Hi Andy,
i have replicated the same for one of my...Hi Andy,<br /> i have replicated the same for one of my assignment, on top of it i would like to see Top and Bottom X records, i have used unique-rank function and dropped it just right to sort field and left to stock, but then the view is splitting up differently for different computations & unable to get the exact row numbers. i have noted that this happen when the date field is in Anonymoushttps://www.blogger.com/profile/17869380072232909513noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-33443511739864935222017-09-26T13:37:12.950+01:002017-09-26T13:37:12.950+01:00Join #MakeoverMonday - www.makeovermonday.co.ukJoin #MakeoverMonday - www.makeovermonday.co.ukVizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-57036855314601146412017-09-26T13:04:13.701+01:002017-09-26T13:04:13.701+01:00Hi Andy,
I am beginner and recently started tablea...Hi Andy,<br />I am beginner and recently started tableau. I found your videos are very much interesting. Please can you tell me where I can find data set to work on ? Anonymoushttps://www.blogger.com/profile/12332354409943769733noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-76407710360374051132017-07-03T13:27:04.856+01:002017-07-03T13:27:04.856+01:00It might be totally unnecessary. It's how I di...It might be totally unnecessary. It's how I did the calc in my head so I went with it and it worked. There are always lots of ways to get to the same result in Tableau.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-80185903346127596282017-06-18T10:30:49.833+01:002017-06-18T10:30:49.833+01:00Hi Andy,
Quick question -
For the Last week ca...Hi Andy, <br /><br />Quick question - <br /><br />For the Last week calculation, what is the reason for including the lookup in addition to the window_sum?<br /><br />ZN(LOOKUP(WINDOW_SUM(IIF([Last Week],ZN(SUM([Volume])),NULL)),0))Cheese Burst Pizzahttps://www.blogger.com/profile/07567944947254305116noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-31402018092276545132017-04-27T07:43:53.855+01:002017-04-27T07:43:53.855+01:00Publish it to Tableau PublicPublish it to Tableau PublicVizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-11213869647620588702017-04-27T04:56:43.945+01:002017-04-27T04:56:43.945+01:00Hello Andy,
I am new to tableau and am mesmerized...Hello Andy,<br /><br />I am new to tableau and am mesmerized your dashboard skills and Awesome work that you do to help us all with good dashboards that we can use in our day to day life. <br /><br />I just tried to prepare a similar dashboard to show the stock price of stocks during a selected period....and by far I was successful and got what I got. May be would you be able to able to help ? Anonymoushttps://www.blogger.com/profile/10168187912518757894noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-54225589596007417582016-09-20T06:34:34.603+01:002016-09-20T06:34:34.603+01:00What if there are different KPIs like a Volume, re...What if there are different KPIs like a Volume, revenue and stuff in retail...how do you show them in a similar chart?Srichandu Nookalahttps://www.blogger.com/profile/14546325250706243147noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-54448660480067895112016-04-25T09:45:32.747+01:002016-04-25T09:45:32.747+01:00The change columns are discrete, so you can't ...The change columns are discrete, so you can't color them. However, if you want to color the dot on the end of the line as a gradual shading, use the calculation from Step 5 on the color shelf.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-81192228812135373612016-04-25T08:56:59.358+01:002016-04-25T08:56:59.358+01:00Hi Andy,
I was wondering how you could implement ...Hi Andy,<br /><br />I was wondering how you could implement conditional formatting on the "change" columns?<br />so that the bigger the change, the stronger the shading color. <br /><br />Placing the calculated field on the "color" icon in the marks card doesn't effect the table at all...<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-79552868417623944492016-04-11T21:31:40.625+01:002016-04-11T21:31:40.625+01:00Me telling you isn't going to help your develo...Me telling you isn't going to help your development. Download the workbook and reverse engineer it. That's the only way you'll truly learn how these table calcs work. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-27445400313572815732016-04-11T21:22:31.217+01:002016-04-11T21:22:31.217+01:00ok ,,i have two questions
ATTR(Date) why do we tak...ok ,,i have two questions<br />ATTR(Date) why do we take ATTR here <br />and what does it retireve and total(max(date) is 31 right ?<br />m123https://www.blogger.com/profile/14409821855689305465noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-12612614399668510472016-04-11T19:29:37.869+01:002016-04-11T19:29:37.869+01:00The calculation starts at 0, so this calcs account...The calculation starts at 0, so this calcs accounts for 7 days 0,1,2,3,4,5,6 where 0=latest day.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-74820944061722004952016-04-11T19:20:45.478+01:002016-04-11T19:20:45.478+01:00lastweek calculation mentioned as
DATEDIFF('da...lastweek calculation mentioned as<br />DATEDIFF('day',ATTR([Date]),TOTAL(MAX([Date])))<=6<br /><br />what isthis 6 ,can you explain on this calculation. m123https://www.blogger.com/profile/14409821855689305465noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-76220184323301113522016-03-14T16:17:11.957+00:002016-03-14T16:17:11.957+00:00You can create a RANK calculation and filter to 1-...You can create a RANK calculation and filter to 1-5.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-47306113386778974132016-03-14T14:03:43.767+00:002016-03-14T14:03:43.767+00:00Hi Andy,
Thank you for this helpful post! I follo...Hi Andy,<br /><br />Thank you for this helpful post! I followed it and it works great.<br /><br />One question though - how would you now show only the top 5 performing stocks?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-82067067492187595542016-03-09T06:05:24.750+00:002016-03-09T06:05:24.750+00:00Hi Andy,
I'm trying to create something exact...Hi Andy,<br /><br />I'm trying to create something exactly like this post (e.g., summary of the overall KPI, and a sparkline over last 30 days), except where the example in this post has the %age Change value I'd like to display an Up or Down arrow depending on whether the change is positive or negative. I'm trying to do this all on one sheet, rather than creating a dashboard of Charliehttps://www.blogger.com/profile/05307717921227386304noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-39487255218383674842016-01-21T20:25:41.713+00:002016-01-21T20:25:41.713+00:00The easiest way to get around it is to put the tab...The easiest way to get around it is to put the table calc as a dimension as the first column in your view (assuming the data goes down the table), then add an index table calc as have it filter to the first 3. There are probably simpler workarounds. Just search the forums and I bet you'll find something.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-20177388978624634862016-01-20T16:00:48.309+00:002016-01-20T16:00:48.309+00:00Thanks Andy! I have one last question. I have a to...Thanks Andy! I have one last question. I have a ton of dimensions and ideally I could just filter by the top 3 movers (week over week difference) for a dashboard. I'm running into issues with a Top N filter I assume because there are table calculations involved. Is there a good way to work around this?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-47886187856466414422016-01-20T15:58:46.860+00:002016-01-20T15:58:46.860+00:00This comment has been removed by the author.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-3764231970454953152016-01-20T14:20:07.444+00:002016-01-20T14:20:07.444+00:00Makes sense to me Jonathan.Makes sense to me Jonathan.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-69087321988761436382016-01-20T13:59:39.081+00:002016-01-20T13:59:39.081+00:00Hi Andy,
I replaced the calculation above with a...Hi Andy, <br /><br />I replaced the calculation above with a parameter to set the Saturday date I was wanting and replaced all the references back to that parameter value, which appears to be working from what I am seeing. Do you see any issues with that solution?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-64324549895225252512016-01-20T02:45:22.155+00:002016-01-20T02:45:22.155+00:00This is a really helpful guide. Here are the 2 cha...<br /><br />This is a really helpful guide. Here are the 2 challenges I'm facing:<br />1 - I need to view the data based on a Sunday to Saturday weekly schedule. I.e., I can't use the max(date) as my reference point. Instead I built a function in its place to find the last Saturday in the data: <br /><br />if datename('weekday',max([Date])) = 'Saturday' then max([Date])<brAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-90592606624421621092016-01-06T22:52:38.917+00:002016-01-06T22:52:38.917+00:00The calculations in this post could easily be chan...The calculations in this post could easily be changed to use parameters instead. For example, in the Last Week calculation, you would change the 6 to the parameter instead. Rinse and repeat for the other calculations.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.com