The x-axis contains the time stamp and the y-axis contains the consumption. I want a selection option on the line chart as shown in the following picture (grey area):
So that when I select the certain area of a line chart, it gives the difference between the start and end time of the x-axis and also add up the consumption of the selected area.
I have no idea how to do that. Any help would be really appreciated. Sample file here
An possible solution might be:
use a x-axis slicer : turn Zoom Slider ON , for the X-axis, a period can be selected from the graph.
However this is not very dynamic, as a user has to set the slicer to the required period each time, for presentation it would work.
Second part of your question:
“So that when I select the certain area of a line chart, it gives the difference between the start and end time of the x-axis and also add up the consumption of the selected area.”
The consumption could become more visible with the Y-axis slicer, starting round the value in the beginning.
Alternative might be a measure for the period, like a rolling period. ( Datesbetween)
Hi @leo_89, did the response provided by @deltaselect help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.
Hi @leo_89, we’ve noticed that no response has been received from you since the 10th of May. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @leo_89, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
