Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Bar Chart with one bar fixed.

Hi amitchandak    I have sales data for multiple countries[let's say - India,USA,UK,Africa,Australia] of 5 years. I would like to create a bar with year and country on the X-axis and sales on the ...
General Comment
Interesting Links
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , No, I doubt that. As of now, we can only sort on column or measure.

    So we can force India to come first by having a sort column.  But can not make others sort on dynamic year value.

     

    Statics yes we can(overall revenue) . https://www.youtube.com/watch?v=KK1zu4MBb-c

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , No, I doubt that. As of now, we can only sort on column or measure.

So we can force India to come first by having a sort column.  But can not make others sort on dynamic year value.

 

Statics yes we can(overall revenue) . https://www.youtube.com/watch?v=KK1zu4MBb-c

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks amitchandak 

 

I was able to achieve a solution by ranking the countries using switch and then sorting the country column on the basis of rank(circular dependency was coming, to overcome that i have create a duplicate of country column and sort the dupliate of country by rank and using duplicate country column in bar char).
If there is any other way please let me know.