KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Sorting date column #421

Open arthur opened this topic on on Aug 17, 2018 - 5 comments

arthur commented on Aug 17, 2018

Hi,

I got an excel file with a column with the name of a client and after each column represent a month (date format in excel) of billing.

So I can have my table with all the results. However, I 'm facing some issues :

  • The date is not correctly display, even with datetime as type of column.

- How could I display a checkbox list letting me choose the months I would like to display ? - And could I make a graph with the billing value per month ?

Thanks !

KoolReport commented on Aug 18, 2018

Do you mean the date is displayed like number for example "42736"?

arthur commented on Aug 18, 2018

Yes exactly

arthur commented on Aug 20, 2018

And my other questions are : - How could I display a checkbox list letting me choose the months I would like to display ? - And could I make a graph with the billing value per month ?

Thanks a lot

David Winterburn commented on Aug 21, 2018

Hi Arthur,

Would you please send your sample excel file and your php code as well? Thanks!

arthur commented on Aug 21, 2018

Yes I will.

As you can see, 1 month = 1 column. I created an aggregated column to have the sum per month. How could I make a linechart with the evolution of this aggregated columns ?

Thanks !

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

Excel