Forum Discussion

Varshi288's avatar
Varshi288
Icon for Resolver II rankResolver II
7 years ago

Can X -axis (bins) dynamically vary

Hi  

I have a orders data in which there is  a measure MP(TP) where it varries  based on currency selection.Initially I created histogram chart based on the values of the measure.this is hard coded with values  when US currency is selected.Now the requirement is  when any currency selected other than US the x axis should varry accordingly.

I am trying to create bins  on measure MP(TP) but I am not succusfull. 

For ex. if I select the US currency  MP(TP ) values  vary  from 0.1 to  >1.  and if i select INR currency  MP(TP) value vary in between 30 to 45 above. this I need to  show in the  histogram chart.

  IS there any way to change the axis dynamically.

 

Need Help
Tips and Tricks

2 Replies

  • jamespiggot's avatar
    jamespiggot
    Frequent Visitor
    7 years ago

    Hi there,

     

    Is there a reason why you don't leave the start and end as auto then it would dynamically scale the axis? If they are blank then the chart will auto-sale the Y axis according to the currency? Apologies if I am missing something obvious!

     

     

     

    • Varshi288's avatar
      Varshi288
      Icon for Resolver II rankResolver II
      7 years ago

       

      Hi James,

      Initially MP(TP) values were calculated  according to  US currency so most of the values are within the range of 0.1 to 1.So Y Axis was hard coded with in these  values. Now MP(TP) values change based on other currecy. Is it possible to  change values on currency selection in a calculated column.