We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3806183
Highstocks Stocks
Closed

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