Forum Discussion
Showing value per date time
Hi community,
I have a data from the SQL query:
And I want to put in the graph to show how value is changing with the exact time.
When I try to do it via Line chart I get different cases, with each one is not what I need. Sometimes it makes Count of the DateTime, sometimes it does count of the vValue, sometimes it does sum.
Im definately doing something stupid, bit I can't find the right setup for it. Can you please help me with it?
Hi LevMalyi ,
Based on the information you provided, this is the default aggregation function for fields with date hierarchies. When the x-axis is year, the value field on the y-axis is aggregated by default based on year.
Below way to get the results you want:
cancel the date column hierarchy.Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
LevMalyi , Default aggregation on Date, datetime and Text column would be count, and you will not get sum option.
For numeric it will be sum.
You can create measure with choice of aggregation
M1= Sum(Table[Value])
Hi amitchandak, thank you for your message.
My understanding, that I don't need a SUM. I want to have a graph with Value on the Y axis and DateTime on the X axis, but when I place those variables on that axis, I get everything except what I need.
Hi LevMalyi ,
Based on the information you provided, this is the default aggregation function for fields with date hierarchies. When the x-axis is year, the value field on the y-axis is aggregated by default based on year.
Below way to get the results you want:
cancel the date column hierarchy.Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Thank you, it solved the issue with the Date, but my values are still showing as a sum, instead of real values, the same as on your picture 🤔
