Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Im using this expresion into a text object:
=Count({<STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {"=year(today())"}, MES_FechaLlamadoOriginal= {"May"} >} distinct IdCallLlamadoOriginal)
the idea its not to use like this because the idiea its to take the month of the current day. So, should be something like this:
=Count({<STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {"=year(today())"}, MES_FechaLlamadoOriginal= {"=month(today())"} >} distinct IdCallLlamadoOriginal)
But it isnt working...
I have tryed with month in number format, in name format and theres no way to make the MES_FechaLlamadoOriginal become equal to the Month.
Whats the problem? I dont know what its going on, really.
Thanks for All!
Germán.
Hi,
At a first glance, the expression should instead look like this:
Count({< STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {$(=Year(Today()))}, MES_FechaLlamadoOriginal= {$(=Month(Today()))} >} distinct IdCallLlamadoOriginal)
Second, make sure that both ANO_FechaLlamadoOriginal and MES_FechaLlamadoOriginal have the same numeric format as the one returned by Year() and Month() functions.
Third, avoid when possible the use of Count Distinct, it takes longer to compute than other aggregation functions and it will slow down your charts if there are some hundreds of thousands of records.
Hope that helps.
Miguel
Hi,
At a first glance, the expression should instead look like this:
Count({< STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {$(=Year(Today()))}, MES_FechaLlamadoOriginal= {$(=Month(Today()))} >} distinct IdCallLlamadoOriginal)
Second, make sure that both ANO_FechaLlamadoOriginal and MES_FechaLlamadoOriginal have the same numeric format as the one returned by Year() and Month() functions.
Third, avoid when possible the use of Count Distinct, it takes longer to compute than other aggregation functions and it will slow down your charts if there are some hundreds of thousands of records.
Hope that helps.
Miguel
Solve!!!!
Excelent!!
Thanks a lot!