Can a bar chart be converted to Straight table ?

[nikhilgarg]

Hey,

Can a bar chart be converted to Straight table ?  I have Cyclic Dmensions

Thanks

[morganaaron]

Converted? It all depends on how your data is structured, but there shouldn't be a reason why a bar chart can't become a straight table - you could simply turn on the fast change option and enable both to allow switching between the two? You can have cyclic dimensions in a straight table.

[anbu1984]

Yes, check this

[nikhilgarg]

Hey,

Thanks . It helped me but now when i am selecting one of the dimension , i am not getting max value at top. While for other two dimensions it works fine.

thanks

[nikhilgarg]

Hey,

Thanks anbu. But i think Aron reply is more helpful. But now when i am selecting one of the dimension , i am not getting max value at top. While for other two dimensions it works fine.

thanks

[morganaaron]

As in it's not sorting the data correctly? What format is the data you're sorting?

[nikhilgarg]

Actually, in barchart i have cyclic dimensiona nd cyclic expression. There it is sorting in correct manner by both ways.

When i create cyclic dim and expr in straight table, it is not working correctly.

Thanks

[morganaaron]

Can you post your .qvw or show a screenshot of what you're using in the sort tab? Are you using an expression or just sorting by default values? Are they numbers?

[nikhilgarg]

Hey,

I can not post qvw. But ltme tell you:

Cyclic dim = User + Country + Department

Cyclic Expression = Expr 1 + Expr2

Under Sort tab:

1: For Cyclic Dim:  I checked Frequency : Descending

2: For very first expr: i checked Numeric value = Descending

But they are not coming correct order.

thanks

[morganaaron]

What are you expecting to see? And what is it showing? Can you give an actual example of the data?

Be aware that sorting your dimension by frequency is equivalent to a count of the expression.