Dynamically creating chart based on responses

  • Resolved madoxx

    (@madoxx)


    1 year ago

    Hello wpDataTables team,

    I am working on a self-evaluation form which should result in user seeing a Polar Area Chart based on their responses.

    For collecting answers, I am using Forminator. They also have a plugin allowing me to directly use responses to create a chart with your plugin (wpDataTables integration for Forminator Forms).

    I already communicated with their support team, and you can read it in this thread.

    I am currently experiencing 3 problems:

    1. When I select columns (Area1 Score, Area2 Score, …, Area10 Score), the first one gets lost and used for the vertical axis. How to fix this?
      Screenshot: https://prnt.sc/xxEOf4TkL_ug
    2. For Chart.js Polar Area Chart I can’t select more than 2 columns, although I need 10. Is this limitation only on the free version of your plugin? Is it possible to use 10 with the paid version?
      Screenshot: https://prnt.sc/NCl8_JOl-P7U
    1. Is it possible to dynamically create chart based only on one set of responses (filter for the table that will only show specific submission data dynamically)? Is this only on the premium version of your plugin?

    Thanks in advance!

    • This topic was modified 1 year ago by madoxx.
    • This topic was modified 1 year ago by madoxx.
    • This topic was modified 1 year ago by madoxx.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    Hello,
    To begin, I want to extend my heartfelt apologies for the delayed reply,which is due to an unexpectedly high volume of inquiries.We truly value your patience during this period.

    I read the correspondence you had with the Forminator Support Team.
    I can see the second Support person told you that in the end, you will not be able to make Charts like that, because simply put – any of the Charts from any Chart Engine will not allow you to have more than one String or date Type Column in it.
    All the other fields can only be Numeric.
    So this will be the main limitation, and that is the same for our Premium and Lite Plugin version.
    That is not a limitation from wpDataTables/ wpDataCharts, but rather from the Chart Engines we use.

    You can either try to somehow split this data up into several Charts;
    So you can place one String( or Date) Column for the first Chart;
    Then another chart presenting the data for the second String/or Date Column, and so on…
    Or, you would have to change the format of your Source Data, if possible to somehow have numeric Data to work with for Chart series.
    There is no other way.

    For the series in the Chart, you can only use Numeric Data;
    And the String/or Date Data can only be used to provide labels for the X axis, it can not be used as Series.

    So the first Column you select/ which will be placed on top in the Chart Wizard, is taken for the X axis;
    While any other columns you add must be Numeric ( Float or Integer) and they are used as the series values.

    –
    When it comes to filtering data for a Chart;
    Advanced Filtering is not available in our lite Version – That is only available in the Premium version;
    It can be done, you will be able to set the Table Shortcode on same Page with the chart and activate the Chart to follow Table’s filtering – but for more details on that workaround, please open a ticket on our main Support platform here, and one of our Agents will respond as quickly as possible.

    Premium products are not supported in these forums, as per this comment by www.ads-software.com moderators.

    Thank you for understanding.

    Thread Starter madoxx

    (@madoxx)

    Thanks for the response!

    …more than one String or date Type Column in it…
    As you can see from the screenshot (https://prnt.sc/NCl8_JOl-P7U) the type of data I am trying to add is Float, so it is a number not String or Date.

    I want to create a chart like this:
    https://apexcharts.com/wp-content/uploads/2020/09/basic-polar-area.png
    Where each color represents a different calculation (see the first screenshot.)

    I just want to understand if this is possible, since I am ready to purchase the premium version of your plugin, but only if I can create such charts dinamically.

    Plugin Author wpDataTables

    (@wpdatatables)

    Hello,
    It depends exactly which Chart Type you will create.
    Each Chart type has certain restrictions of how many columns it can have form a Table.
    Looking from your screenshot, you have chosen one of the Chart types that can take a maximum of 2 columns in Total, regardless of the column type.

    For example, if you choose to make a Pie chart, it does not matter which Chart Engine you pick, all Pie Charts can have a strict requirement of exactly 2 columns, not less or more.

    So it can be 1 string or Date Column and 1 numeric;
    or it can be 2 numeric Columns – but if you pick only 1 column, it says “minimum of 2 columns is required”;
    And if you pick more than 2, it says “2 is maximum”.

    You can learn more about all the possible Apex Engine Chart types we have available in this Documentation.

    But we are not allowed to discuss anything in details when it comes to Premium features on this Forum, so best will be if you can please open a ticket on our?main Support platform here, and one of our Agents will respond as quickly as possible.
    They can advise you in more details, you can also try out the premium Plugin on our Demo Sandbox, they will guide you to it, etc.

    Premium products are not supported in these forums, as per this comment by www.ads-software.com moderators.

    Thank you for understanding. 

    Kind regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Dynamically creating chart based on responses’ is closed to new replies.