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...
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!