Forum Discussion
Cumulative Total Per Hour
You can create a measure to filter the table in a time period and then count the rows,
e.g.
measure=
var _timeStart= use function to get your time start
var _timeEnd= use function to get your time end
return
calculate(countrow('table'),filter(all('table'),'table'[time]<= _timeEnd && 'table'[time]>= _timeStart))
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Good afternoon, I am trying to implement the solution they are providing me but I do not understand very well this part, where they tell me:
var _timeStart= use the function to get your time started
var _timeEnd= use the function to get the end of your time
Could you explain to me what functions are you referring to? o How can I create them? I as I tell you I have a catalog of the hours between 8 in the morning and 20:00 hrs but I do not understand very well How can I call it through a function? I hope you can support me with that. In advance I thank you infinitely
Best regards
The function needs to be customized according to your model.
Usually we need information below, could you provide it? Thanks
(1) a sample file, you can replace raw data with bogus data to protect your privacy.
or provide some sample data that fully covers your issue/question.
(2) give your expected result based on the sample you provide.
Kindly note: Please ensure the data in sample is concise and representative.
Thanks.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hello!!
I generated the file, but when I try to upload it it sends me this error:
Can you tell me how can I share them?
The other way I came up with is by taking screenshots...
These are my data:
My lookup table
My Catalog of hours
How to show my cumulative closing agreement with the range of hours (this I generated manually, for the example)
As you can see my graph (All the hours mark me 13, because it is the total of queries I have, but it does not report the cumulative sum of closures per day)
As you should see... Increasing from 0 which is how you start the account to 13 which is the total of my queries
Thank you very much for everything, I am attentive to your comments
Best regards