Sorting Dimension by Date

[Anonymous]

Hello all,

I have a chart where I have two dimensions, Business Case Number and Case Status, I want to see it ordered by date and what I'm currently doing is on the Sort tab under the Chart properties using the expression '=Date'

The issue is that I can't show label under the X-axis to see the dates, since my dimension is the Business Case Number, but I still need to see each individual case pm the chart, and if I use the Date as a Dimension it'll consolidate the ones that have the same one.

I thought of using a calculated dimension, but not sure how. Any ideas?

Thanks!

[agomes1971]

Hi,

please see this:

Hide a Dimension

HTH

André Gomes

[Anonymous]

Hello André!

I don't want to hide it, I actually want to sow it, but not as business case, but as date.

[agomes1971]

Hi,

please attach a sample so I could help you.

Thanks

André Gomes