Hey everyone!!
I have two tables in my script one for sales and one for orders.
What I need to do is in the reload process create a temporary table that'll be read into a chart object showing my top sales and orders for a given dealer.
I want to group on the dealer and count all the sales in the sales file per dealer and then do the same with the orders. The table should look like this:
Dealer - sales - orders
then I'll chart the sales and orders with dealer name in the legend below for the top ten only.
How do I do that in the load process without generating another QVX from Alteryx?
Example code is welcomed!!
.png "Former Employee"){kind=icon}
