Date problem is Charts

[0li5a3a]

Hi  all,

I have a strange situation where the days are not displayed right.

This is my expression  count({<Date = {"<=$(=DATE(MAX(Date)))>=$(=DATE(MAX(Date)-6))"}>}TICKETID)

This is the Dimension:  Day.

Like you can see I selected the maximum day - 6 to display the last 7  days. As you can see below I suppose to see the day  the data on this logic : 29,30,31,1,2,3,4.

Could please someone advise ?

[Anil_Babu_Samineni · Accepted solution]

Yes, Make sense. You need to play around with Sort tab? If not, I would ask you to provide sample work file to test

[arvind_patil]

Hi Constantin,

Please try Below:

count({<Date = {'>=$(=DATE(MAX(Date)-6)) <=$(=DATE(MAX(Date)))'}>}TICKETID)

Thanks,

Arvind Patil

[0li5a3a]

I tied the options from the Sort Tab  but hey don't work.....

I would try to create a simple scenario....

[kusumanchir]

Hi Constantin,

Try giving Date as expression in the sort tab.

[effinty2112]

Hi Constantin,

As Anil suggested the sort tab might have the answer to this. Maybe sort by Expression : Date

cheers

Andrew

[0li5a3a]

Hi,

I have added now the condition Date like you said and now I have I think the problem sorted:)

[0li5a3a]

Thanks you all sorted now:)

[0li5a3a]

Sorry guys  but after a better check is looking like all the above they are not right. Soo the problem is still open.

[tresesco]

What is wrong? What are you expecting to see? Could you post a sample qvw?