Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
i have two chart with the total information, for each number i have one expression.i need to calculate the total % on weekly basis. kindly help me
Table1 | Table2 | |||
Issue Names | Prior Week Total | Issue Names | Current Week Total | |
A1 | 310 | A1 | 316 | |
A2 | 2 | A2 | 8 | |
A3 | 8 | A3 | 6 | |
A4 | 0 | A4 | -8 | |
A5 | 316 | A5 | 306 | |
A6 | 344 | A6 | 333 |
Expected Output
Issue Names | Prior Week | Current Week | WoW % Change |
A1 | 310 | 316 | 2% |
A2 | 2 | 8 | 300% |
A3 | 8 | 6 | (25%) |
A4 | 0 | -8 | 0% |
A5 | 316 | 306 | (3%) |
A6 | 344 | 333 | (3%) |
Now i need to merge these two charts to calculate the %,
could some one help me with the logic.
Thanks in Advance
Navin
Create the output table, the other tables should be linked through the Issue Names field in the data model.
Simply create the first 3 columns as dimensions, then in the last column create the expression:
([Current Week Total]-[Prior Week Total])/[Prior Week Total] and label it as WoW % Change, format the result as an integer, Show in Percent
@Lisa_P thanks for your reply
Im bit confused implement this logic, do you want me to create output table in script side. Suggest me