Forum Discussion
Syndicate_Admin
4 years agoAdministrator
Cumulative Total Per Hour
Hello again Sorry for the inconvenience, I have another question, I have a total of consultations in a period of one month, let's say 1000, however, at the end of that time, I need to know how ma...
Syndicate_Admin
4 years agoAdministrator
Thank you for answering me @Syndicate_Admin, I have been trying to implement it, but there is something that I do not understand very well, you tell me that I have to create a table with the date and from there extract the time, I in the information I have, I have a column where the closing hours are. At the time of applying the code I would have something similar to this:
Acumulado = CALCULATE(SUM('consultas consultas[statuscerrados]), FILTER(ALL('consultas consultas'),'consultas consultas'[hora_cierre] <= max ('consultas consultas'[hora_cierre])))
If I put it in my graph everything gives me 1 😥 and well that is not the correct result, for example between 9 and 10, there should be 647
In advance thank you very much
Syndicate_Admin
4 years agoAdministrator
Hello, sorry for the inconvenience, will anyone have any news with the latest I said?
In advance thank you very much