Bad Date Ordering in Pivot Tables

[elviseras]

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

[rmcdonald]

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

[support]

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.

[elviseras]

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

[support]

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

[elviseras]

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

[support]

Just try it.

[elviseras]

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

[support]

Well, then use just number.

[support]

Also see documentation
https://www.php.net/manual/ru/function.date.php

Code: Select all

$today = date('\i\t \i\s \t\h\e jS \d\a\y.');   // it is the 10th day.

It means you can use "\" to insert custom text in format. So in your case format will be

Code: Select all

\W\e\e\k W

Let me know if it works.