Rukovoditel Support Forum

Hi,

When making a report with Pivot Tables about progression of amount of support tickets over time, there is a problem with data sorted alphabetically because when using a date field this order is not valid and should be sorted by date. See the attached images....
I would appreciate it if you reviewed it as soon as possible...

Regards

Yes we have the same problem - had to number the months and limit the year to get around it a little

Yes, there is issue with this report. It always use alphabetic order. You can configure data format so as solution just add year and month number at the start.

Hi Sergey,

You can configure data format so as solution just add year and month number at the start.

Can you tell me how to configure this ?? I've tried but I can not get it to work...

When you setup fields for pivot report you can configure custom date format. See attached

Ok Sergey thanks..now I understand

Just one more thing .. Is it possible to insert some character in the date format, in addition to the space? How should I write it so that it is not identified as a date variable?

regards

Just try it.

Ohh, I've already tried it but it does not work. Example: I need to put the word "Week" to identify the weeks (Week 34, Week 35 and so on), but always interpret the variable W and enter the week number (34eek 34, 35eek 35 and so on).

I've already tried putting it between single quotes ' and double quotes " but it does not work either

Well, then use just number.

Also see documentation
https://www.php.net/manual/ru/function.date.php It means you can use "\" to insert custom text in format. So in your case format will be Let me know if it works.