Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Locked API: How to only select working hours

Hi,

 

I am connected to an API for our phone call statistics in the company. This means that I have dashboards showing salesmen activity on calls.

 

I have a column in the API named 'enter_time'. This column shows the time the call is made. I want to exclude calls that are from 17:00 to 08:00.

 

I don't have access to creating own tables when connected to this API.

 

I was hoping to filter the report by using the advanced filtering for 'enter_time' and using 'starts with' 08,09,10,11,12,13,14,15,16.

 

But it seems I cannot use multiple values in this field?

 

Could you help out? Can I use DAX? The only button I can press is 'new measure'. As mentioned, I cannot create other columns.

 

Thanks in advance!

 

/Kris

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,

    Create the following measure, then drag the measure to visual level filter of your visual and set its value to 1.

    Measure = IF(LEFT(MAX(Table1[enter_time]),2) in {"08","09","10","11","12","13","14","15","16"},1,0)


    Regards,
    Lydia

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    Firstly, please change data type of the enter_time column to Time as shown in the following screenshot.


    Measure = IF(MAX(Table[enter_time])<TIME(8,0,0) ||MAX(Table[enter_time])>=TIME(17,0,0),1,0)


    Secondly, drag the measure to visual level filters of your visual, and set its value to 0.


    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous

       

      Hi Lydia,

       

      Thanks. As mentioned this API is locked. (see print screen). I can only press New Measure, not the other columns since this API is locked.

       

      I guess this is not possible to solve then?

       

      Thanks!

       

      /Kris

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous,

        Create the following measure, then drag the measure to visual level filter of your visual and set its value to 1.

        Measure = IF(LEFT(MAX(Table1[enter_time]),2) in {"08","09","10","11","12","13","14","15","16"},1,0)


        Regards,
        Lydia