🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

plotting chart with year from a date column

Answered
amir asked on April 22, 2021

I have a flexmonster chart with some date fields. Now i have two requirements for the date fields
1: Date in table view should be a single column (not divided into day, month and year)
2: I should be able to plot chart on year (or month) from the date field
For the first requirement, I set the date type to be ‘date string’ but now i am not able to plot by year and if i set date type to ‘date’ it will allow ploting chart by year but will show date as 3 columns (day, month and year) hence failing first requirement.
How can i achieve both of the above requirements

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 22, 2021

Hello,
 
Thank you for reaching out to us.
 
It seems we have answered this question earlier on our forum.
 
You are welcome to see the corresponding thread by the link.
 
Please let us know if it works for you.
 
Kind regards,
Illia

Please login or Register to Submit Answer