6 Replies Latest reply on Jun 24, 2016 12:22 AM by yorick.bakker

    Dashboard export not showing decimals on Y-axis

    yorick.bakker Rookie

      We seem to have an issue with exporting dashboards, to illustrate:

       

      We have component showing availability where the Y axis shows values between 99 and 100% in steps of a 10th, so 99.1, 99,2 and so on till a 100. The issue now is that when this component is exported to anything else than a image, the Y axis values are rounded down to whole numbers and the Y axis show 99, 99, 99, 99, 99, 100, 100, 100, 100, 100,100 which makes it useless to export.  How can we get those figures to not round down and show the decimal values as shown in the Xtraction interface ?

       

      screenshot interface showing .10th values on the Y axis:

      Screenshot Xtraction interface.png

       

      screenshot pdf export showing only whole rounded values:

      Screenshot Xtraction Export.png

        • 1. Re: Dashboard export not showing decimals on Y-axis
          cjensen SupportEmployee

          Hello,

           

          I have duplicated this issue in my test environment and have alerted our development team through a logged defect (321366). I will keep you updated with the status. Thank you for bringing this to our attention.

           

          Thanks,
          Channing

          • 2. Re: Dashboard export not showing decimals on Y-axis
            yorick.bakker Rookie

            Thank you Channing,

             

            Just to inform you, as i did not get a response so far i also added this issue as a support request with no. 00895824

            • 3. Re: Dashboard export not showing decimals on Y-axis
              pkenderdine Employee

              Can you provide details of your component:

              • Component Type
              • Chart Type
              • Details of any properties set on the component and series that differ from the default values

               

              I suspect this is a bug in the export but will need these details to confirm and to see if there is a work around. If the UI shows decimal places then it would be expected to see the same decimal places shown on the export chart.

               

              Regards

              Phil

              • 4. Re: Dashboard export not showing decimals on Y-axis
                yorick.bakker Rookie

                Hi Phil,

                 

                In answer to your inquiry:

                 

                Component Type is Time Component

                Chart Type is Area Stacked 100%

                 

                Properties that differ from default on the Component are:

                Output tab: Y Axis range set to min 99 max 100

                Output tab: Show Percent (Series) is ticked

                 

                Properties that differ from default on the Series are:

                Output tab: Color set to green (1st series)

                Output tab: Color set to red (2nd series)

                 

                Regards,

                Yorick

                • 5. Re: Dashboard export not showing decimals on Y-axis
                  pkenderdine Employee

                  Hi Yorick,

                   

                  The export is not outputting percentages with decimal places. This has been like this for some time. Recently we introduced additional axis tick mark formatting but percentages were not included. I agree this should be fixed. I have added this to be looked at in the next quarter. All being well it should be available in v2016.3. Unfortunately we are out of time to get it into v2016.2 which is in system test at the moment.

                   

                  I didn't quite get enough time to work on a workaround. Perhaps you could look at using calculated series. Something along the lines of:

                  Series 1 Uptime, Visible == false

                  Series 2 Downtime, Visible == false

                  Series 3 Total, Visible == false

                  Series 4 (Calc) if([S3] > 0 , [S1] / [S3] * 100, 0)

                  Series 5 (Calc) if([S3] > 0 , [S2] / [S3] * 100, 0)

                   

                  You might need to uncheck series percentage property on all series so the output will give you a decimal value between the range of 99 - 100 or depending on your data.

                  The syntax used for calculated expression can be found here: NCalc - Mathematical Expressions Evaluator for .NET - Home

                   

                  I haven't tested this so it might take some time getting it to work if you are able to get the correct output. Good luck. If I get a chance to test this theory then I'll post something here otherwise I hope to get it fixed later this year.

                   

                  Regards

                  Phil

                  • 6. Re: Dashboard export not showing decimals on Y-axis
                    yorick.bakker Rookie

                    Thanks for your response Phil, all clear.