Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Chart displaying difference between 2 lines chart

Good morning all I have a 2 lines chart with dates as x axis and price as y axis ( like a stock chart displaying 2 stocks prices by day, see below screenshot bottom chart). So I have this 2 lines c...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Nope, you can't use analytics features to analyze the diff of your fields. You need to create a new measure to calculate the difference between two fields.

If you confused on coding formula, please share some sample data for test:

How to Get Your Question Answered Quickly  

Regards,
Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    tks Xiaoxin 

    I could do the trick by unpivoting the Query and adding a table to select the chart I wanted. see result in pict.

    Now that I can select what I can display the two daily prices series I want to create a measure that calculate the difference between the 2 daily prices series. How can I do that (in case someone knows)? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI Anonymous ,

      Can you please share some dummy data with the same structure for test? It seems like you have converted your table structure.

      Notice: do mask on sensitive data.

      Regards,

      Xiaoxin Sheng