Skip to main content

Hi Team,

 

I’m working on input dropdown where my timestamp should be convert into daily,weekly,monthly and if it is daily I need 8 hrs , for weekly 40 hrs and monthly 173 hrs in one single dropdown. How I can achieve it.

 

Regards,

Ajith Naidu.

Use a custom object to create the dropdown 

customObjects: 
  - id: TIME_DROPDOWN
    displayName: Time Dropdown
    customAttributes:
      list:
        - name: DAY
        - name: WEEK
        - name: MONTH

 

When selecting the data assign it to a variable, next all you need to  is put in a YAML code i,e, like 

${(VARIABLE === 'DAY' && 8 ) ||(VARIABLE ===   'WEEK' && 40)}

 

Depending on the use case you should be able to change the same accordingly 


Hi ​@abhishek.chatu14 ,

 

I am trying to build it in new studio views not in legacy views. How I can implement it using input dropdown.

 

Regards,

Ajith Naidu.


Similar approach you can use the Input dropdowns with manual input and assign the data to a variable, now use this vairable to do the calulations

Configuring user inputs (input box, input dropdown, button)


Hello ​@abhishek.chatu14 , I have the same issue. In legacy views I have created a custom object with the attributes e.g. year, year-month, quarter, week, day. I have now added an input dropdown “save user selection to” time_dimension (view variable). The doc now requires to create a PQL. I would have to create a PQL per dimension, year, year-month etc. It is also not very clear on how to add this: 

I have created an exemplary attribute MONTH(“_CEL_P2P_ACTIVITIES”.”EVENTTIME”) AS month and then tried to add it like this ${_Cel_p2p_activities.month} → this does not work at all and I would still have the problem with the different dimensions I want to select.

Could you please support me here?

 

Thanks and best regards,

Julia Bauer 


Reply