Okay
  Public Ticket #3554401
Historical Yearly Weather Data Monthly
Closed

Comments

  • Elias started the conversation

    Hi,

    I came across those documents 

    https://wpdatatables.com/weather-table/ 
    https://wpdatatables.com/documentation/table-examples/monthly-summary-report-temperature/ 

    And been wondering how one can use wpdatatables to have a chart / graph like the one I have attached to this ticket. 

    I assume this will be quite challenging, so I was looking into other options like this example:

    https://www.nomadstays.com/stay/Tolani-Hotels-Resort-Koh-Samui#:~:text=Samui%C2%A0by%C2%A0Tolani-,climate%20in%20maret,-Weather%20this%20week 

    I guess this might be easier to implement as I am not a developer, but I am wondering where / how to get this data into the table.

    Could you please help or give me some directions?

    Thanks allot.

    Elias  

    Attached files:  climate-chiang-mai-thailand.png

  •  1,698
    Miloš replied

    Hi Elias,

    The example as from your attached screenshot, i believe this will not be possible by only using our currently built-in Chart types and options.

    7743226508.png

    Sorry to disappoint you, but at this time, we don't have any built-in solution to achieve this.

    You can suggest it to our developers, though - they will do their best to make a solution in the future.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    -

    If you need to achieve this now with a Custom Solution, you can only try to customize one of the existing Charts, but please be advised that custom solutions are not covered by our Support.

    Every chart engine has its own layout and its settings.

    We use free libraries for chart engines, and they are limited as to what we can change from within the plugin's UI.

    You can check out all the available chart engines and examples of wpDataCharts documentation here . 

    If the options you need are not in the chart creation wizard,  you can try to find a custom solution using chart callbacks.

    You can check our documentation about wpDataCharts callbacks

    • Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts APIHighcharts API, and Chart.js API
    • All necessary resources are available in charts engines API (depends on which one you use). Every engine has a different approach to chart settings. In wpDataChart callbacks, you have to adopt those settings to the wpDataChart object (you can take a look at examples for each engine in our documentation, and also in the Support help center). A huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and Google will search only that website). Also, a lot of examples of charts, chart settings, and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")
    • Please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.




    2. Now, this second example you found, i believe you should be able to create a Chart like that with our "out of the box" Chart types and options.

    4345617142.png

    This is what we call a "combo Chart", because you will be combining multiple Types of Series on the same Chart.

    In that example, you would first pick the "Months" Data for the first Column on this Chart, to provide the intervals+labels for your X axis.

    Then, you would combine, for the Column "Tpical Rainfall", you would chose a Column Series type;

    And for both the "minimum temp" and "maximum temp" Columns from the Table, you would pick Line Series on the Chart Wizard.

    You would also activate having double Y axis labels.

    I will explain that in more details :

    -

    From our wpDataTables version 2.2 it is possible to create charts with multiple Y axis in order to show different units on the same chart.

    This is only available for Apex Charts, and HighCharts.

    On the Series tab, in the chart wizard, there is an available option to change the type for each Series and to set a multiple y-axis.

    For Apex charts it is possible for the following Chart Types : 

    Line chart, Spline chart, Stepline chart, Basic area chart, Spline area chart, Stepline area chart, and Basic column chart.

    For the HighCharts Engine it is possible for :

    Line chart, Spline chart, Basic area chart, Basic bar chart and Basic column chart.

    Please note that HighCharts and Apex chart engines are only included in the premium version of wpDataTables, they are not available in Lite version.

    -

    1296511346.png

    -

    6975863126.png

    You can try this out on our Demo.

    Let me know if you have any questions.

    3. When it comes to getting your Source Data into a Table;

    Our Support does not cover building source Data or building Tables, but we will do our best to advise you or to provide examples as similar as possible.

    -

    Can you tell me, do you already have some Source Data, and if so - where is it stored, is it perhaps on a Speadsheet, or in an SQL Database,  or on a Weather API, anything like that?

    If you can show me more details how the data is structured, columns and rows, and what is the desired goal for it to be presented on a Chart, etc?

    -

    Maybe the best place to start will be to check out these combo Chart examples i sent above with different Series Types and multiple Y Axis - that is very similar to the second example you sent;

    And if you struggle with any step along the way, let us know, we will be here to help.

    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Elias replied

    Thanks Miloš for your reply.

    I will try to figure this out and if any more questions come up I might be back. ;)

    Elias

  •  1,698
    Miloš replied

    Hi Elias,

    I spoke with our QA Team in the meantime and tried my best to provide more useful details, to try and get your 'first example' working.

    7743226508.png

    The only 'as close as possible' example we have is on this Apex Charts Page on our Documentation.

    Find it at the bottom, under the title "

    Synchronized Charts
    Visualizing data in more charts with synchronization

    ".

    9742888120.png
    7655644035.png

    As you can see, this is a Custom example of  using the  wpDataCharts callbacks to pull several Charts like that.

    If you have coding skills, you can try it out, and you can modify it to edit/ or add chart options you need.

    ( For more details on customizing Charts, you can still refer to my previous reply on that subject)

    -

    Or, this other example from the same Page : ApexCharts 100% stacked bar chart.

    5162114838.png

    You could use this for "overcast" and "hot" use-cases of Chart presentation(s).

    So, depending on your knowledge and if you have some coding skills to try to customize the Chart(s) further to get 'closer' to your desired example, you might be able to achieve it, we just can't guarantee exactly how close you can get to that specific solution.

    Just as we stated before, please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice;

    and our Support also does not cover building a Data Source or Tables/ Charts for Users, but we do our best to provide examples and guide you where you can start, when it comes to specific use-case like that.

    I hope that helps.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables