Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Scatter Chart: Comparing values in same column

NameDateValue
MaTMP1/1/2022 8:00 PM50.04
MaTMP1/1/2022 7:45PM50.06
MaTMP1/1/2022 7:30 PM50.6
OaTMP1/1/2022 8:00 PM33.49
OaTMP1/1/2022 7:45PM34.10
OaTMP1/1/2022 7:30 PM33.80

 

 

Here is sample data that i am using to create a Scatter Graph.  I am tring to have the MaTMP and OaTMP on the 2 axis and doing it by the date/time.  I have created 2 measure for these two points

MaTmp = CALCULATE(SUM(Query1[ActualValue]),FILTER(Query1,Query1[PointName]="XRDCWPDBSADX02:STNCRST-NAE02/N2-1.021083DX.MaTmp.#85"))
OaTmp = CALCULATE(SUM(Query1[ActualValue]),FILTER(Query1,Query1[PointName]="XRDCWPDBSADX02:STNCRST-NAE02/N2-1.021083DX.OaTmpGlobal.#85"))

I dont want to use the legend since there is 96 rows per day and i needing to trend this over a full year.  Below is what i am trying to recreate.  Any help would be appreciated.

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Create 2 columns:

    MaTMP = IF([Name]="MaTMP",[Value])
    OaTmp = IF([Name]="OaTMP",[Value])
     
    Use for your X-Axis and Y-Axis set to Sum. Use your Date as your Details.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous Create 2 columns:

    MaTMP = IF([Name]="MaTMP",[Value])
    OaTmp = IF([Name]="OaTMP",[Value])
     
    Use for your X-Axis and Y-Axis set to Sum. Use your Date as your Details.