Receive email notifications by changing your settings.
Click on your picture in the top right corner, go to Preferences and select your notification preferences.
Thank you for contributing to our forum!
Please keep in mind:
1. To only comment on the topic where the discussion is about. Do you have a new question or topic? Please start a new discussion.
2. Be kind to other users!

Multiple indicators from one Excel

Did you know it's possible to have multiple panels or indicators come forth from a single Excel? It's a technique I've applied in the past when converting pre-existing Excels into Tygron Platform indicators. Often, so much information comes forth from such a tool that it's desirable to split the output over multiple indicators or panels, but specifically not to split op the intelligence of the underlying calculations.

The trick is to create (or modify) an Excel, such that it has multiple potential EXPLANATIONs and SCOREs, calculated in parallel. In the Tygron Platform you then create multiple excel indicators, each with an attribute named (for example) MODE. Each Excel Indicator has a different value for the MODE attribute. In the Excel itself, the MODE attribute is read out using an ID_QUERY, and based on its value a specific explanation and score are actually placed in the output cells.



You can try it out yourself. Attached to this post is an excel which will either output data and scoring based on the presence of green, or based on the presence of nature.

  1. Upload the attached excel into your Tygron Platform project
  2. Add an Excel Indicator with an Attribute named MODE and a value of 1
  3. Select Excelsheet, then upload the excel and select it for the Indicator.
  4. Create an additional Excel Indicator with an Attribute named MODE, but set the value to 2.
  5. Select Excelsheet, and rather than uploading an excel again select the one that is already loaded into the project.
  6. Both indicators are now based on the same Excel, but output different explanations and scores!

(To see the scores properly, activate "Use Absolute calculated Score" for both indicators)

There are a few caveats when using this approach.

Your excel cannot contain UPDATE statements (unless they use WHERE-INDICATOR-IS-ID as selector), otherwise the two panels' calculations may attempt to change the same data into potentially different values, which is an error.

Additionally, because both indicators compute a final state of the indicator in their own way, both indicators will compute the entire excel on their own. This means that if your Excel is particularly complex or computationally heavy, you should take into account that this approach is not the most efficient method performance-wise.

Despite these points of attention, this is a trick that has made implementing provided business intelligence a lot more streamlined more than once, and might be of use to you too.

Tagged:
Sign In or Register to comment.