Forum Discussion

LevMalyi's avatar
LevMalyi
New Member
2 years ago
Solved

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 ca...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • LevMalyi's avatar
    LevMalyi
    New Member
    2 years ago

    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 ğŸ¤”