Hi Adetweiler,For the Standard Deviation you may want to simply edit the SQL and run that function directly on the table in the physical schema itself, alternatively you could create and MV and use STD function and curate the MV to support your use c...
Hi Prabhak,Please clarify with further detail on what you are trying to accomplish if I miss the mark here. It appears to me that you are simply trying to reduce the resultset. This may be ideal to simply add into the SQL scripts. Again, If that is t...
Hi Marc,Here is an example I have extended upon the previous. In the first image you can see that within the pivot function after the 'PIVOT(avg(AvgLineTotal' you can then simply add a comma and add the next aggregate 'SUM(OrderQTYTotal)' as shown in...
Here's how this can be solved using an MV with Spark SQL:I'm using an 'AdventureWorks' database, if your not familiar its simply a sample database often used for testing for a retailer that has tables such as OrderDetail, OrderHeader, Products, Produ...