Hello again! Help with Avgcounts, Min Max and Std Dev

[sravan2013]

Hi,

Can someone help me in deriving the desired output as in the attached document.

Brief Summary: I have transactions data for each day for the past 8 years  (in fact it is at timestamp level). So i would like to create a summary dashboard that shows the Count of transactions, average transactions by Month, Min transactions max transactions that happened in that month and also Standard deviation.

Thank you!

[Lisa_P]

Hi Sravan,

I have loaded your data with a simple script as follows:

Input:

LOAD TimeStamp,

     Month(TimeStamp) as Month,

    Year(TimeStamp) as Year,

    Date(MonthStart(TimeStamp),'MMM-YYYY') as MonthYear,

     ID

FROM [lib://Downloads/Sample Input and Output.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

This gives you some Date dimensions to work with.

Then on the Sheets, create a straight table and add your measures..

[sravan2013]

Thank you Lisa. Can you please share with me the qvf file that you worked on? Thanks alot for your help!

[Lisa_P]

QVF attached