Pivot Buckets not picking for dates.

[tvisha]

Hi,

I have created a dimension with buckets as ,

=If(num(Date(floor([Date Created]))-Date(today()))<=5,'1-5',
If(num(Date(floor([Date Created]))-Date(today()) )<=10,'6-10',
If(num(Date(floor([Date Created]))-Date(today()) )<=20,'11-20',
If(num(Date(floor([Date Created]))-Date(today()) )<=30,'21-30',
If(num(Date(floor([Date Created]))-Date(today()) )>30,'More than 30 days')
))))

I am trying to plot a pivot table, however it is taking just the first bucket and not rest. I have done the same in other apps and it is working fine, not sure why not here.  Am I doing something wrong with the date? Any help. 

Also in the measure I am adding the count , as count(case reference number) however it is not coming correct.

or I need to plot a graph something similar, 

Any other help way I can create this?

Thanks,

Rains

[Or · Accepted solution]

Assuming [Date Created] is something that happened in the past, [Date Created] - Today() is always going to be a negative number, so it follows that you will only ever get the first bucket - negative numbers are always smaller than 5. If this is indeed the case, you need to reverse either your subtraction or your if() statements accordingly.

[tvisha]

Thank you, That worked. Silly mistake. I rectified that in other calculation, but missed here.

[tvisha]

IS there a way I can plot a bar graph from the same?