Icon for Differences over year in Text area thanks to Calculated value

[Remi COURTEY]

Hello TIBCO Community :)

I have an issue with an expectation of one of my client.

We have data from 2019 & 2020, and we want to display an Evolution rate (Difference % Year over Year) in Text Area.

For that I used a Sparkline to display my value because I have the [Axis.X] function in my calculation, and the calculated value property can't support this function.

My client wishes to have a icon next to the evolution rate displayed. If the evoution rate is negative, the iconis a red arrow down. Contrariwise, If the evolution rate is positive, the icon is a green arrow up. But when I put my Evolution Rate calculation in the custom expression Value, the icon is not supported the [Axis.X] function and I can't display anything.

 

I'm not looking for a workaround because we found a soukltion with the KPI Chart with Color Coding but our client wants it into a Text Area with an Icon.

You'll find in attachment a dxp with Data and visualisations.

Someone can help me

Thank you

[Franck Leonard]

Hello

 

May you use a calculated value with this formula :

((Sum([Questions asked]) - Sum([Questions asked]) over (PreviousPeriod([Year]))) / Sum([Questions asked]) OVER (PreviousPeriod([Year]))) - 1

 

Seems working is you have 2 years available.