You're close! You need to create a view variable.

Once you create this view variable, you'll be able to both update it using your dropdown and then code it into KPIs, Filters, etc. for dynamic use.

Hey @matt.witty13 ,

thanks for your reply.

Two questions:

1) What is the default value in the view variables? Do I have to insert the PQL statement that is also used in the KM coding? I tried it like this and it does not work unfortunately.

2) In the previous construct with the analysis I have had a filter with the time dimension (e.g. month, quarter). In the charts the x-axis was displayed with the support of a variable:

I'm now struggling to convert this into a view as in the chart settings in a view, I cannot select a variable like this, I found out that only a KPI and the SAP fields are available for selection.

Could you help me with this?

Thanks so much for your input already.

BR

Julia Bauer

The default value is NULL, which is fine. What you'll have to do is set the dropdown to update this variable like you have in this screenshot:

You set the "variable" in this screen to be the view variable you've created.

From there, you'll need to setup where the variable is going to update. I have an X-axis on a chart which is setup in the same way.

That is the view variable that is getting updated by the drilldown button. So my X-Axis, whenever something in the drilldown is selected, will update to whatever field is selected in the drilldown.

This is my current setup:

I'm not sure if I have to create a view variable per variable, e.g. Year, Quarter etc.? Or do I have to consolidate it to a view variable called "TIME_DIMENSION"? I'm asking because I think something is still missing in my construct as my chart unfortunately does not get updated.

Thanks for your help!

Kind regards

Julia Bauer

Okay so now you're going to make a view variable and use the custom object to update it. The view variable example I provided earlier goes with this custom object:

So whenever I make a change to this dropdown, it'll update the view variable.

What I will add is the custom object will only contain "specific" values. So your custom object will display a list of "Year, Quarter, Year-Month, Week, Day". Just those words, no formulas. I'd recommend making an attribute and that's what you're using to update what you want to update.

I'd also look through this page - a lot of good info : https://docs.celonis.com/en/views-variables.html#UUID-8808e9b5-f434-b598-3298-7dd183ddc913_id_ViewsVariables-UseCasesforVariables

@julia.bauer  and @matt.witty13  Have you try Button dropdown in new views

If so, please share me the steps need to implement.

Hello @kandi.naidu !

It still does not work within my view.

I will update you once it works for me.

Best regards

Julia Bauer