Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Scatter Chart Axis Format Using a Calculation Group

Greetings Community,

 

I am trying to create a basic scatter plot: Volume in lbs. on the X-Axis and a selected measure on the Y-Axis.

 

The X-Axis format needs to be a whole number and the Y-Axis format needs to be in dollars to the second decimal place.

 

The reason I am using a calculation group is because I want to be able to slice by a selected measure and have only the Y-Axis value change - the X-Axis measure will always remain the same calculation which is Volume.

 

I have done all the proper format strings in the calculation groups however both the X and Y axis values are showing in dollars instead of dollars and whole number.

How do I get my scatter chart to format the X and Y axis correctly?

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , is it possible to share the format code. to me seem like issue with formatting

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak are the pictures I provided above what you were looking for?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak 

     

    Thank you for the response. Are you asking for the Calculation Group format string? If so, below is a screenshot of the format string for Volume (whole number) and one example of rate per pound. (dollar value)

    Gross Sales rate per poundTotal sales volumeCalculation ItemsSELECTEDMEASURE