creating a list box property control where to control several KPI formulas to show on the same graph

[Enkeled Kanaj]

Hi,

 

Who can help with a case or link where it is explained how to do a list box property control where to control several KPI formulas to show on the same graph.

 

It is supposed to work so: when we select a KPI name on the list box the relevant KPI appears on the graph which changes the name and values automatically. So avoiding navigation on several pages.

 

[Olivier Keugue Tadaa]

Hi Enkeled

choose the Listbox (multiple select)  and create a property control of type String List and set property values through Expressions

 

Then you will add this custom expression ::::  $map("((${expressions}))", ",")

Good luck

 

[Enkeled Kanaj]

Hi @Olivier Keugue Tadaa

I don't have this option string list:

[Olivier Keugue Tadaa]

Have you chosen the Listbox (multiple select)  ???
If you want to plot more than one KPI in your visualization,

If you only want to display one KPI at a time let me know.

[Enkeled Kanaj]

Hi @Olivier Keugue Tadaa

 

yes selected single one.

 

now How  I can map to the graph:

 

[Olivier Keugue Tadaa]

What do your expressions look like ?  

[Enkeled Kanaj]

There is a ploblem,

 

After the list box list is created it can not be edited to add a new KPI:

 

 

 

100 - (([pmCellDowntimeAuto] + [pmCellDowntimeMan]) / 60 / [PERIOD_DURATION] * 100)

[Enkeled Kanaj]

Hi @Olivier Keugue Tadaa

 

this is a an example from a company how it maps automatically to the graph. this is through list box (single select).

JUst wnated to learn how to create my own reports like this where whenever we click on the list box the kpi shows automatically here:

 

 

[Olivier Keugue Tadaa]

No problem,

For a single selection, proceed with the below steps

1- insert a property control and choose List Box
2- create a document property (e.g. expressions) of type String
3- in the "set property values through", choose Expressions
4- add your expressions (display name, and expression) (see below)

 

5- on your y-axis, choose "custom expression" and add ${expresions} as the expression

 

 

Now you can choose your KPI an view it on your visualization

 

 

Edited August 12 by Olivier Keugue Tadaa

[Enkeled Kanaj]

Hi @Olivier Keugue Tadaa

What about display name because it shows the formula?

[Olivier Keugue Tadaa]

for a user-friendly display name, you will have to do something like this 

[Enkeled Kanaj]

44 minutes ago, Olivier Keugue Tadaa said:

5- on your y-axis, choose "custom expression" and add (${expresions}) as the expression

Hi @Olivier Keugue Tadaa where you find this custom expresion

 

[Olivier Keugue Tadaa]

right-click and custom expressions  then add copy paste this : ${expresions} ,  (assuming "expression" is the name of your document property defined in step 2)

Edited August 12 by Olivier Keugue Tadaa

[Enkeled Kanaj]

Hi @Olivier Keugue Tadaa

 

Now a new problem: want to add another formula from a another table to the property control but it recognizes only those from the first table

 

[Olivier Keugue Tadaa]

if you want to add more than one dynamic formula, then choose my very first suggested approach, but I believe you've understood how that overall mechanism works ... you can now adapt to your constraints. For example, you can add the  ${expresions} anywhere it will make sense with the other expressions.

 

[Enkeled Kanaj]

Hi @Olivier Keugue Tadaa

 

Going to a formula of another table does not function

[Olivier Keugue Tadaa]

your visual is based on one data table and you want to add an expression on a column from another data table .???  there is a way to achieve this as explained here... 👇

https://docs.tibco.com/pub/sfire-analyst/14.4.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=md%2Fmd_multiple_data_tables_in_one_visualization.htm%23bc-1&rhtocid=_4_3_0

 

[Olivier Keugue Tadaa]

Happy to hear that the initial request has been successfully done. I'll mark this as the solution.