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?
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?
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
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?
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?
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