Forum Discussion
ElliotP
Post Prodigy
Post ProdigyCompare Last Week's Sum and Past Two Week's Sum Average
Afternoon, I'm trying to build a guage to compare the sum of last week's sessions with the average sum of the past two weeks. For Example: Week One: 10 Page Hits Week Two: 20 Page Hits ...
thank you CheenuSing!! That worked !!!
:)
hi CheenuSing,
Just a quick check.. can i use the same logic to add a formula into "Add column" instead of a measure? if so what will it be ?
and also is there a way to combine tables (Table1+Table2+Table3) that you see in the attached screen shot into Table 4, cause i have calculated measues on these and i have filtered the weeks that i need accordengly and now i just want to combine these into 1 table in the visualization page. and this new table 4 should allow me to add more measures.
is there a way to do this?
ideally i need to achive as below:
Part Avaialble Qty Last 4 Wks Shipment Last 4 Wks Avg Shipment 6 Wks DDS 6 Wks Avg DDS Part a 39,636 23,360 5,840 43,003 7,167 Part b 0 0 0 0 0 Part c 53,929 19,674 4,919 37,230 6,205 Part d 0 0 0 0 0 is this the correct way or is there a better way to do this?
Thanks