Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am working on a Bar Chart with two dimensions, one is material, the other is date.
Material | Date | Inventory |
---|---|---|
M01 | 1st Jan | 40 |
M01 | 2nd Jan | 45 |
M01 | 3rd Jan | 48 |
M02 | 1st Jan | 60 |
M02 | 2nd Jan | 92 |
M02 | 3rd Jan | 70 |
I have created a Bar Chart based on this table and after the selection for material, the chart will be about date and inventory.
If i need to compare the value with its previous one, and mark the sharp change as another color, how can i fetch the previous value?
For example, for M01, 2nd Jan, i need to get 40 as it is the previous value for 45.
Could you please help?
Regards
Got it. I added a field using Previous() to create previous value in the script.
Got it. I added a field using Previous() to create previous value in the script.