topic Pivot Buckets not picking for dates. in App Development

Pivot Buckets not picking for dates.

tvisha — Mon, 15 Aug 2022 10:25:22 GMT

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

Re: Pivot Buckets not picking for dates.

Or — Mon, 15 Aug 2022 10:44:08 GMT

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.

Re: Pivot Buckets not picking for dates.

tvisha — Mon, 15 Aug 2022 10:49:02 GMT

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

Re: Pivot Buckets not picking for dates.

tvisha — Mon, 15 Aug 2022 10:49:51 GMT

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