Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have to show a straight table with 4 columns ( Product,Stage1,Stage2 and Stage3)
In this table I need to show the total number of days the product was .which should be calculated from one date field .
This is how my data is like . If you look at the data for the product Milk in Stage1 the date is 01-01-2021 and this product Milk moved to stage 2 on 23-02-2021 and so on, based on this we need to calculate the number of days a product took to travel from one stage to another .
Date | Stage1 | Stage2 | Stage3 |
01-01-2021 | Fruits | Chocolate | Rice |
23-01-2021 | Milk | Fruits | Chocolate |
12-11-2021 | Fish | Milk | Fruits |
Thanks in Advance
Hi Everyone,
Any suggestion on my above post ?
Thanks
Hi All,
Any suggestion /Help ?
Hi All,
This is how I want to show the output in a table , Currently I am calculating manually by I want to know is there way to make it load in script or can we use in an expression ?
Product | Stage1 | Stage2 | Stage3 |
Milk | 323 | ||
Chocolate | 22 | ||
Fruits | 23 | 323 | |
Rice |