Forum Discussion

bfaivre's avatar
bfaivre
Regular Visitor
9 years ago

Plot Values (y axis) vs. Time (x axis)

Hello,   I’m sure I’m missing something really basic here. But I have data that I retrieve from a database. The first columns represent timestamps and the second columns represents values. I simply...
bfaivre's avatar
bfaivre
Regular Visitor
9 years ago

Thanks for all the input. This still isn't working for me. Surely it can't be that difficult to plot values on the y-axis over time on the x-axis? This is so much of what we do on a daily basis vs. showing the count of the data points (or another aggregate).

 

Does anyone have an viable example or tutorial they can share?

 

Thanks in advance,

 

Brian

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi bfaivre,

This is so much of what we do on a daily basis vs. showing the count of the data points (or another aggregate).

In order to show the count of the data points on a daily basis, you need to change Date Hierarchy to Date for Axis and use Sum for your Values. Then you should get the result you want.

If that is not the case, could you post some sample data and the expected result in your case?

 

Regards

  • JohannesHamburg's avatar
    JohannesHamburg
    New Member
    9 years ago

    I am trying to do the same thing. Time is on X , Value is on Y. Time is in the right format YYYY.MM.DD hh:mm:ss.

    I can plot every value in the right order. Since I want to analyse the data for a month, I have like 50.000 Datapoint.

    Now I want to aggregate or digg into the data. 

    Just like it is already possible with Year, Quarter, Month and Day, I would like to extend that Hierachie to hour and minute.

    Thanks for help!