Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Age Slot | # of Incidents |
< 5 Days | 65 |
5 to 10 Days | 55 |
11 to 30 Days | 124 |
> 30 Days | 509 |
Total | 753 |
Hi I have this PIVOT chart object. I am able to sort it perfectly like shown above. The AGE SLOT column is in order.
But when I do some selections - Like if I am selecting some team name then this order is getting changed as shown below.
Any specific reasons?
Age Slot | # of Incidents |
11 to 30 Days | 4 |
> 30 Days | 5 |
< 5 Days | 5 |
5 to 10 Days | 6 |
Total | 20 |
Hi
Try like this
Load *,
If(Days < 5, Dual('<5 Days', 1),
If(Days <= 10, Dual('5 to 10 Days', 2),
if(Days <= 30, Dual('11 to 30 Days', 3), Dual('>30 Days', 4))) as "Age Slot"
from datasource;
Then
In Pivot table -> Sort , use Num([Age Slot]) in Expression and Ascending.
Hope it helps
Have you tried it with a dual-field from [Age Slot]?
dual(string-value, numeric-value)
- Marcus
Hi Vijay,
go to Sort -> check Expression -> type
sum({1} Age)
Hope this might help
Hi,
Check in Sort tab, might be you have opted ascending in Numeric value.
Hi Marcus,
What is dual(string-value, numeric-value) and where I have to use it?
Hi
Try like this
Load *,
If(Days < 5, Dual('<5 Days', 1),
If(Days <= 10, Dual('5 to 10 Days', 2),
if(Days <= 30, Dual('11 to 30 Days', 3), Dual('>30 Days', 4))) as "Age Slot"
from datasource;
Then
In Pivot table -> Sort , use Num([Age Slot]) in Expression and Ascending.
Hope it helps