Data360 Analyze

 View Only
  • 1.  Data3Sixty - Pie and bar charts

    Posted 06-12-2020 13:07

    I have exported my data into a Tableau workbook so I can create pie and bar charts that way but is there a way to do that in Data3Sixty? Do I need to install pandas? Any suggestions would be appreciated.



  • 2.  RE: Data3Sixty - Pie and bar charts

    Employee
    Posted 06-14-2020 04:01

    You can use the Python node to leverage the pandas and the matplotlib Python packages to create plots.

    Attached is a zip file that explains how you can install 3rd party Python packages into the site-packages folder of a Desktop Analyze instance. The document describes the installation of numpy and pandas. In addition to this you will need to install the matplotlib package.

    The Python_Node_Output_TimeSeries_Plot_Image.zip file contains an example of how you can use the matplotlib package to create a chart image - in this case consisting of multiple series data corresponding to time series forecast data. Matplotlib can be used to create bar and pie charts - see the documentation for the package or other online resources.

    A Generate Data node is configured to specify the filename of the csv file containing the source data for the chart image and name of the file in which to save the resulting chart.

     

     

    The Python node is configured to read in the source chart data filename and the chart output file name. 

     

    Pandas is used to read in the data as a data frame and construct individual data frames for each of the series to be plotted in the chart. The matplotlib module is then used to create the plot lines and add labels and a title to the chart. The generatd chart is then saved as the specified image file.

     

    The example chart image will be as follows:

     

    Attached files

    Install_numpy_pandas_in_Data360_Analyze.zip
    Python_Node_Output_TimeSeries_Plot_Image.zip

     

     



  • 3.  RE: Data3Sixty - Pie and bar charts

    Employee
    Posted 06-14-2020 22:39

    The data flow in the above zip file requires the use of Analyze v.3.6.0 or above.

    Here is a version of the data flow that can be used with Analyze v.3.4.x

     

    Attached files

    Python_Node_Output_TimeSeries_Plot_Image_432--share - 15 Jun 2020.lna