6 Replies Latest reply on Aug 1, 2018 3:48 PM by swaroop.gantela

    Radial Chart


      Hi All,

      I am trying to create Radial chart following below blog.


      Vizible Difference: Radial Bar Chart Revisited .


      How ever, I am not able to replicate this Radial Chart.  I used the super store data and created a workbook which is just showing me a single chart .


      Also, I have attached the screenshot of my chart with my actual data. (this is just screenshot) but much similar to workbook I have attached.

      I am unable to get the Radial chart like in the blog. 

      I have used exact same calculation .


      can anybody help me with this chart?

        • 1. Re: Radial Chart



          Based on your screenshot, I'm not sure if these two points

          will apply to your true workbook, but I think I was able to get

          your example workbook to separate the rings.


          One point was that the blog version looks to have only had

          one value for each ring, whereas in the Superstore, there

          are multiple values that need to be aggregated.

          And so instead of SUM(Sales) in Rank and Path,

          I used { FIXED [Category]:SUM([Sales])}.


          Looking at the sample data in your workbook,

          I wasn't sure if it was complete, as there should

          be two identical sets of data, one with Type 1 and the other with Type 2.


          Please see workbook v10.5 attached in the Forum Thread.

          • 2. Re: Radial Chart

            Hi Swaroop,

            I tried mocking up my data and attached the workbook.

            I am aggregating the data in the workbook and it is not pre aggregated data.

            As I change the Request type filter, I have to get my chart ranked accordingly.


            Also, I tried following below video and this is also not working.



            • 3. Re: Radial Chart
              meenu choudhary

              Hi Susheels,


              Please refer below video:



              • 4. Re: Radial Chart



                I simplified the [fixed Units] because I think you are wanting

                to just rank on Status:

                { FIXED [Status]:SUM([Units])}


                I then used that throughout the other calculations.

                As you are wanting to adjust by Request Type, I added that filter

                to the context:

                Improve View Performance with Context Filters


                Please see if this is closer to the goal.

                Workbook v10.5 attached in the Forum Thread.


                • 5. Re: Radial Chart

                  Hi Swaroop,


                  with this Fixed stuff, radial chart works fine . How ever, with fixed stuff it is not working for me.


                  with out the fixed, units is ranked differently across status . when I fix, units is ranked differently.


                  so what is happening is, when I fix it, I am getting radial chart ranked as per the fixed value and not same as the just units value.


                  Can we do this without fixing units and just across units ?

                  • 6. Re: Radial Chart



                    You can set your desired level of granularity by denoting the Dimension you want

                    in the Level of Detail calculations:

                    { FIXED [Status],[Month Date],[Providence],[Request Type]:MAX([Units])}


                    Also please note the use of MAX(Units) since there are multiple copies on account

                    of the Path Bins (please see Sheet 6 of the attached).


                    The granularity of data should also be reflected in the Table Calculation settings in X and Y

                    only for the Nested Calculation of Rank (please see screenshot below).

                    You may need to adjust the Restarting Every as needed.

                    Also please note that Request Type was added to the Context.


                    Please see sheet "Changed Granularity" in the workbook v10.5 attached in the Forum Thread.