Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My target is to build something similar to a statistic box, but
- with indicators based on several field
- with different set of selection
My table would have 2 columns [Statistic label] and [Statistic value]
For example:
Number of incidents for current month | Value
Number of incidents for previous month | Value
%Increase (m/m-1) | Value
Number of incident YTD | Value
Resolution time (hours) | Value
....
Each cell of the 2column should have its own expression (made of 'Set Analysis').
For the moment, I import the definition of my statistics, coming from an Excel file. And with a macro, I would like to process the 2nd expression which contains the expression (in text) in order to retrieve the real value
I wanted to used a TableBox with the method SetInputFieldCell, but it does not seem to accept expression.
Another idea, would be to process the expression within the macro, and paste the value inside the TableBox (But i think it is not that clean)
Any better idea?
You might tell me to use a pivot table and put enter all my expressions. But they will be displayed as columns. Is there any ways to transpose it? So my columns becomes rows?
Thanks in advance,
topic closed.
Chart properties > Presentation > Allow Pivoting