Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I have a straight table with quite a few dimensions and one expression :
Sum ({<STATUS = {'OPEN'}, TYPE = {'TECH},LOCATION = {'UK'}>} AGE)
How can I limit the table to the top 10 oldest tickets based on this expression? TIA!
Within the object-properties to this table is a tab restrictions - here you could specify this quite easily.
- Marcus
You sort per value and in the properties the chart, on sheet Dimension Limits, you need to check restrict which values are displayed using the first expression.
Regards
Marcos Freire
Within the object-properties to this table is a tab restrictions - here you could specify this quite easily.
- Marcus
Ahhhh I had show other values ticked, hence it didn't work previously. Thanks all!
Go to chart properties-> Dimension limit -> check restrict which values are displayed using the first expression. -> Select largest and Values =10