Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have four charts, and I have an expression for the 4th chart, as follows to avoid filter `Job' being applied to it. =sum({<job=>}Sales).
TestName Roomtype Job Type1 Type2 Type3 Type4
AN large 1 4 1 6
BN small 3 1 1 7
CN medium 2 1 5 1
After the filter Job = Type3 is applied, it puts the Type3 column in the very first column for the 4th chart. Example below in red. How can I have it displayed in ascending order after the filter is applied: example: Type1 Type2 Type 3 Type4
TestName Roomtype Job Type3 Type1 Type2 Type4
Referring to this on your other post:
Monalisa01 said:
So Job is not one of the options that is displayed within sort, so this is what I did, within sort, select any one of the dimensions, in my example above I would select Testname and add expression =job then select ascending order and text (A-Z).
Change that to be =only({1}job) and it will ignore selections.
Referring to this on your other post:
Monalisa01 said:
So Job is not one of the options that is displayed within sort, so this is what I did, within sort, select any one of the dimensions, in my example above I would select Testname and add expression =job then select ascending order and text (A-Z).
Change that to be =only({1}job) and it will ignore selections.
Nicole Smith you are the best. Thank you very much, that worked like a charm
Nicole Smith Hello,
Apparently this =only({1}job) works when you first add the expression. When I come out and save out of it and go back in again, it does not work. And it also does not work when I publish the dashboard.
Any ideas.
It should always work (I've used the same thing on many of my dashboards). If you're seeing something different, you'll need to post a .qvw file.
Preparing examples for Upload - Reduction and Data Scrambling
Seems like it is working now. Thanks for your prompt response.