tag:blogger.com,1999:blog-3178813192704651028.post4780292710690307712..comments2024-03-17T17:57:14.785-04:00Comments on The Flerlage Twins: Analytics, Data Visualization, and Tableau: Creating NPS Gauges in TableauKen Flerlagehttp://www.blogger.com/profile/03698843288892226027noreply@blogger.comBlogger113125tag:blogger.com,1999:blog-3178813192704651028.post-57967101589650001132023-11-10T16:58:44.298-05:002023-11-10T16:58:44.298-05:00I'd just float text boxes on a dashboard.I'd just float text boxes on a dashboard.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-37296631306183748752023-11-10T16:58:20.101-05:002023-11-10T16:58:20.101-05:00Could you email me? flerlagekr@gmail.comCould you email me? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-27613427284373159972023-11-09T20:22:52.618-05:002023-11-09T20:22:52.618-05:00Hey, I wanted to ask about the parameters: the NPS...Hey, I wanted to ask about the parameters: the NPS test, is that a float or integer? What should I put as "current value"? And NPS Value, I'm trying to set it to "String", so I put "Test Value","Real Value" in "current value"?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-57246416463062292042023-11-08T16:51:41.858-05:002023-11-08T16:51:41.858-05:00Can you email me? flerlagekr@gmail.comCan you email me? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-3681565585054533472023-11-08T05:12:13.515-05:002023-11-08T05:12:13.515-05:00how to put labels at the start and end of gauge ch...how to put labels at the start and end of gauge chart? like for me it ranges from 0 to 1000Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-63160791547741906982023-06-23T02:07:41.391-04:002023-06-23T02:07:41.391-04:00Hi Ken.. I tried your approach and am failing. I h...Hi Ken.. I tried your approach and am failing. I have a seperate data source and replaced the NPS to my data set but still seeing issues with creating this one. I followed both your original one and the latest and still have issues.<br />The problem with it .. I dont know how to replace the values correctly. I dont have 100 and -100 but different values ... I have been requested to create this data set fairly shortly but struggling to create this properly. I dont know if if its because I am a newbie or simple dont know how to follow and set it up. theoretically I get it but the actual work .. seems tougher than it is.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-79649291843055982332023-04-06T18:05:57.492-04:002023-04-06T18:05:57.492-04:00I wanted to add something here for people stuck on...I wanted to add something here for people stuck on the same thing I was for hours. I am calculating my NPS in a calculated field, NOT bringing in the score pre-calculated. I have the raw feedback results (scores between 0 - 10) in a column in my data source.<br /><br />Im using:<br /><br />ROUND(AVG(<br />IF [NPS]>=9 then 100<br />ELSEIF [NPS] = 8 or [NPS] = 7 THEN 0<br />ELSEIF [NPS] < 7 then -100<br />END<br />))<br /><br />But when I do this I get: <br /><br /> The calculation ‘SUM of Slicex’ cannot be applied to a user defined aggregate.<br /><br />What I had to do was change my Measure Values for each Slice to:<br /><br /> AGG(Slice1)<br /><br />if you work it through with a fixed value for testing you will have SUM functions in those.Buck Bardhttps://www.blogger.com/profile/01009372823348594232noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-44756323351364384692022-12-16T13:08:23.211-05:002022-12-16T13:08:23.211-05:00Can you email me? flerlagekr@gmail.comCan you email me? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-51726419953259251092022-12-16T02:28:30.510-05:002022-12-16T02:28:30.510-05:00Hi. I have the same issue but I cannot find the re...Hi. I have the same issue but I cannot find the response to Dylan. Any help much appreciated!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-76213700252310260322022-05-23T14:59:15.375-04:002022-05-23T14:59:15.375-04:00Can you email me? flerlagekr@gmail.comCan you email me? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-9678386466222166472022-05-20T13:58:32.857-04:002022-05-20T13:58:32.857-04:00The measure values are somehow getting duplicated ...The measure values are somehow getting duplicated when coloring i.e. (I have slice 1, red and then slice 1 green) not sure what's going wrong hereAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-42542567086055223532021-12-15T15:55:15.025-05:002021-12-15T15:55:15.025-05:00Yes. Happy to help if you could email me. flerlage...Yes. Happy to help if you could email me. flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-14626720307922588002021-12-15T01:48:37.259-05:002021-12-15T01:48:37.259-05:00Hello Ken, thank you for answering my question, bu...Hello Ken, thank you for answering my question, but I forgot to mention that I also try to move the scale only from 0-100 and not from -100. And that's where I'm failing at the moment ... can you please help me? Thank you and greetings, EmirEmirhttps://www.blogger.com/profile/07283943764635854672noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-43638330907749261822021-12-14T16:42:55.362-05:002021-12-14T16:42:55.362-05:00Set the "Highest Bad Value" parameter to...Set the "Highest Bad Value" parameter to 60 and the "Highest Normal Value" parameter to 80.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-13109770859429305572021-12-12T10:49:11.974-05:002021-12-12T10:49:11.974-05:00Hello Ken, I need your help: which values do I hav...Hello Ken, I need your help: which values do I have to change to get the following scale:<br />0-60: red<br />61-80: yellow<br />81-100: green<br />As soon as I try to adjust the values, it ends up in chaos for me. Thank you for your help. EmirEmirhttps://www.blogger.com/profile/07283943764635854672noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-46447461239375583292021-05-20T10:24:18.588-04:002021-05-20T10:24:18.588-04:00Yes, you should be able to do that.Yes, you should be able to do that.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-54806686535716600042021-05-20T02:08:48.328-04:002021-05-20T02:08:48.328-04:00Hi Ken. These visuals helped me out last year with...Hi Ken. These visuals helped me out last year with my excel data and were just amazing.<br /><br />Now, since I have been working on live data now (from Salesforce) and I have scheduled refreshes set for that, I was wondering if this NPS gauge chart would work for that as well? (in context with scheduled data refresh) <br /><br />And apologies beforehand if you already answered this question above in the section.Anonymoushttps://www.blogger.com/profile/15563658912596626027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-1316535296694272522021-04-28T21:08:17.953-04:002021-04-28T21:08:17.953-04:00Can you send me an email with some sample data? fl...Can you send me an email with some sample data? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-39551466470587248302021-04-28T16:23:27.199-04:002021-04-28T16:23:27.199-04:00Hi Ken, Thank you for your work on NPS Gauge Chart...Hi Ken, Thank you for your work on NPS Gauge Chart. I have a requirement at work to build this. However, I can't get it to work. My dataset is not setup exactly like yours. I have survey results with each line item being a survey answer. NPS is a calculated field.<br /><br />Detractors=countd(if [Answer]='1' or [Answer]='2' or<br /> [Answer]='3' or [Answer] ='4' or<br /> [Answer]='5' or [Answer]='6'<br /> then [Answer Id] end)<br />Promoters = countd(if [Answer]='9' or [Answer]='10' then [Answer Id] end)<br /><br />NPS = [Promoters]/COUNTd([Answer Id]) - [Detractors]/COUNTd([Answer Id])<br /><br />I am trying to duplicate your 2020 workbook. But Slice 3 keeps taking up most of the pie. Couple of things I have noticed that are different from your workbook are<br /><br />1) "Color" field on marks card gets pulled in as an aggregate "AGG(Color)"<br />2) Same with Slice 1,2,4 & 5. They get pulled in as Agg rather than Sum. Only Slice 3 gets pulled in as Sum.<br /><br />Could that be causing this or is it the NPS calculation?<br /><br />I wish I could have given you a screenshot here.<br /><br />Thank you for your help.<br /><br />LEJhttps://www.blogger.com/profile/03905232635548552812noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-52994362595166116512021-01-08T09:07:33.344-05:002021-01-08T09:07:33.344-05:00I received an email yesterday, which asks a simila...I received an email yesterday, which asks a similar question. Can I assume that's you? If so, I'll get back to you via email as soon as I can.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-66778468709009404532021-01-07T11:04:30.743-05:002021-01-07T11:04:30.743-05:00Hello Ken - Thanks so much for your trailblazing w...Hello Ken - Thanks so much for your trailblazing work on gauge charts. I have one question - how can I change the colors from 3 to 4 - like red, yellow, light green and green? Anonymoushttps://www.blogger.com/profile/15795458783596814413noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-29571087779424976352020-07-29T10:20:56.987-04:002020-07-29T10:20:56.987-04:00Thank you so much, Ken!! This helped very muchThank you so much, Ken!! This helped very muchJacquellinehttps://www.blogger.com/profile/05288137979744039425noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-39777965874545835632020-06-21T16:44:15.591-04:002020-06-21T16:44:15.591-04:00Could you send me an email with a sample packaged ...Could you send me an email with a sample packaged workbook? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-26600137664598189132020-06-19T06:55:39.629-04:002020-06-19T06:55:39.629-04:00Hi Ken,
Thnanks for this important Aritcle.
In my...Hi Ken,<br /><br />Thnanks for this important Aritcle.<br />In my dashboard NPS score calculated using measure hence that score is aggregate score.<br />So due to aggregate score while creating color and chart value what change we need to do exactly.<br />I have created as per below<br />>>Color<br />IF ATTR([Slice_No])=3 then "None"<br />ELSEIF ATTR([Slice_No])=5 OR ATTR([Slice_No])=2 THEN "Grey"<br />ELSEIF [NPS]>0 THEN "Green"<br />ELSE "Red"<br />END<br /><br />>>chart value as per below<br />CASE ATTR([Slice_No])<br />WHEN 1 THEN [Value_Slice_1]<br />WHEN 2 THEN [Value_Slice_2]<br />WHEN 3 THEN [Value_Slice_3]<br />WHEN 4 THEN [Value_Slice_4]<br />WHEN 5 THEN [Value_Slice_5]<br />END<br /><br />after that chart is not show result as per requirment.<br /><br />Please help<br /><br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-38664059617552935912020-06-11T21:49:19.901-04:002020-06-11T21:49:19.901-04:00Sure, could you send me an email? flerlagekr@gmail...Sure, could you send me an email? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.com