Hi Guys,
May you please assist me with this analysis I have been struggling with for weeks now. This analysis has 2 parts
I have monthly transaction data that I am trying to workout the following on alteryx to recreate what's in the pivot table in PIVOT TAB:
Part 1:
Part 2
Daily Average Per Branch Centre and Monthly Average of Grand total transactions for the month :
Also If you could please try to group by or retain the Trans_Date column so that I can use this column to create a powerBI column and line graph with Day as X axis, Averages on Y axis and sum Quantity of transactions per day as columns.
Attached is the sample data and pivot table I am trying to recreate.
Solved! Go to Solution.
Hey @Sakhile, how does this look? Any issues let me know.
Thanks for getting the figures.
May you please format the below figures to appear as Columns so that I can use them in Power BI Graph:
Monthly Average of Grand total transactions
Monthly Average of Grand total transactions*1.2
Daily Average All Centres
I also need the Trans_Date column to use as X axis in the graph
Hey @Sakhile, do you mean like this? I've assumed you want the average/average*1.2 as a constant or reference line so it runs throughout. I've split this off into a separate container for your PowerBI output. If not, if you can give me the exact format of the expected outcome then that'd be great. Amended workflow attached:
On a side note: Ditch Power BI and use Tableau! :D
Yes ! You are a Genius !!!!!!!!!!!!!