Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table with users activity data as following:
Date (D-M-YY) | User | Resource | Elapsed Time |
1-1-19 | User 1 | Resource 1 | 1 |
1-2-19 | user 2 | Resource 1 | 2 |
1-1-19 | User 3 | Resource 2 | 2 |
1-2-19 | User 4 | Resource 2 | 1 |
I want to build a pivot table as the following and ADD A TREND INDICATOR ARROW (If trend is up=red up arrow / If trend is down=green down arrow)
Resource | January (Average Elapsed T) | February (Average Elapsed T) | Trend arrow |
Resource 1 | 1 | 2 | UP RED ARROW |
Resource 2 | 2 | 1 | DOWN GREEN ARROW |
How can I build this??? I NEED A FORMULA OR SOMETHING THAT ANALYSE THE TREND (I will have many resources and I want to have the monthly average elapsed time and the arrow should take into account the months showed in the table and indicate the trend)
Thank you all
Hi,
Check this post from today: https://community.qlik.com/t5/New-to-Qlik-Sense/Arrows-in-Straight-table-with-Values-Qlik-sense/m-p/...
Here I give the solution for your question.
Jordy
Climber
Don't know how to scalate it
What do you mean with 'scalate'?
Jordy
Climber
How apply it to my data