Forum Discussion

dsrikanth's avatar
dsrikanth
Regular Visitor
9 years ago

Create a simple hour vs time span graph with out aggregation

I have a spreadsheet which has two columns, which are time stamp and observation. Total 86400 records for each second. That means each second has its own observation like Drill, wash, Roll etc. like...
Need Help
ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

dsrikanth Create calculated column for HOUR and MINUTES using dax as below. Then use scatter chart with x-axis as hour, y-axis as minutes, timestamp column as Details and observation column as Values.

 

=HOUR(tableName[columnName])

 

=MINUTE(tableName[columnName])

dsrikanth's avatar
dsrikanth
Regular Visitor
9 years ago

Hi Ankit,

 

Thank you for your response

When i am trying to plot against hour and minute defaukt these values are aggreagred to count and i am not able to change.

 I have time stamp column and derived HR and Min columns from it and marked them to text. Though default aggregation taking place. How to avoid aggregation?

 

Thanks

Sri

  • Vicky_Song's avatar
    Vicky_Song
    Impactful Individual
    9 years ago

    dsrikanth, why you don't want to show the aggregation value in the chart? If you want to show detailed data for every record, you have to choose the Table chart. Like ankitpatira mentioned, you can create a hour slicer to filter second's records, then convert observation into different online color blocks images.