Hey everyone!

With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:

Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.

We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.

In the meantime, if you need help, feel free to:

https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos

https://www.youtube.com/@wpDataTables/videos

Thank you for being so understanding, and we hope you enjoy the long weekend! 

Okay
  Public Ticket #3806183
Highstocks Stocks
Open

Comments

  • Michael started the conversation

    Hello, 

    I have a table that has a String column `MonthDay` that has the format of the Month Name and Day of Month. For example, Jan-01, Jan-02, Jan-03. Then I have a support column called `FiscalDate` which is a date column that has a matching date from 2020. The FiscalDate is used for sorting the rows by the correct order. The other columns I have are data columns with Float/Decimal/Integers.

    I want to use the HighCharts Stock chart that has the Chart as well as the panning/zooming window below it.

    Currently, it forces me to only Select the FiscalDate column for the X-axis. But I do not want to show the Year portion of the date, and rather need to only show the Month-Day labels. 

    Is there a way to use a labels column for the X-axis, or format it to show a specific format rather then the default date format?

    Also, is there a way to preformat the panning/zooming window to be set to the last X days, or months of the available period?


  • Michael replied

    Also, when using the HighCharts Stock chart - it does not ignore non-existent dates, and plots them as Zeros.

    For example, I have data for Jan-01 and Jan-03, so the chart shows jan-02 as zero and it drops to zero line. Is there a way to ignore these empty/non-existent dates?

  • Michael replied

    Well, on this page of yours

    https://wpdatatables.com/documentation/wpdatacharts/highcharts-stock/?utm_source=docs-23868&utm_medium=buy-premium&utm_campaign=wpdt&utm_content=wpdt

    It says that HighcChart Stock can accepts one String or or Date column - but when I am trying to add a String column that looks like Jan-01, Jan-02, it says I cannot use String:

    Please do not add any string-type columns that are not a Date or Datetime column
    Please provide a Date or Datetime column to be able to use HighCharts Stock charts

    Which conflicts with your documentation:


    Attached files:  highcharts stock spline.JPG

  • Michael replied

    Hello - any type of response on this issue? I just checked it - and I am still not able to use anything but a Date column to plot a HighChart Stock - although your documentation says it should be possible. 

  • Michael replied

    WILL ANYONE PLEASE RESPOND?

  •   Miloš replied privately