Silly question about graphs

[#1]

Hello !

On the tiny sample application attached, we have a graph where we would like to show the bars in decreasing order.

That is, largest sales channel (most effective by the number of sales) should appear first.

How to do that ?

Another thing : some sales do not have the field "CHANNEL" filled with content. Is my approach on the graph correct ?

Thanks !

Sorry for such a silly question !

[#2]

Hi,

i'll try..

If u want to sort by channel, reorder the dimension. In your case the first dimension must "CHANNEL_TEST", go to current object Properties to change this. After reorder the dimension then u must defined how the data is sorting, go to tab "Sort" select "CHANNEL_TEST" (should be in the first row) and then select Y-value and choose descending.

Some sales do not have the field "CHANNEL" filled with content, it seems that is from ur data. I already create a table box and load all field, u can see in that table box that there's some blank data in field CHANNEL.

hope this will help.

[#3]

OK I could reorder the dimension.

However, I really would like to see the TIME on the X-Axis.

The idea is to track how the channels are being used along the time.

So, we're back to my original question.

As for the fact that some CHANNEL fields are in blank, that's intentional. My original data is like this.

Cause I need to know how to wipe them out from my graph.

On my example I used an IF on my expression. But I dont know if that's correct or is the best approach.

Thanks !