How to create a customized Dashboard in QV?

[#1]

Hi Everyone,

I am working on requirement to create a customized Dashboard in QV.. which should show the latest activity for last 6 months.

I have a data set worth of 1 year and with daily activity format as below.

Input:

Date	Cumulative Sales
1-Jan-2014	10
31-Jan-2014	40
2-Feb-2014	55
27-Feb-2014	105
3-Mar-2014	125
21-Mar-2014	165
30-Mar-2014	300
Etc.,

Desired Output:

Header	EOM-1	EOM-2	EOM-3	EOM-4	EOM-5	EOM-6
Date	30-Mar-2014	27-Feb-2014	31-Jan-2014	NA	NA	NA
Cumulative Sales	300	105	40	NA	NA	NA

Much appreciate your guidance and help on this!

Thanks,

Prakash

[Colin-Albert]

Have a look at some examples for dashboards and charts you like.

Copy the chart into a new sheet on your app, then adjust the dimensions and expressions to use your fields to get the chart working. Usually get one dimension and one expression correct and the chart will start working with your data.

[whiteline]

Hi.

If it's supposed to be static you can calculate it in the script.

Just create a table (Date, Header) using autogenerate(6) and addmonths() function.

Then you can simply use  the Header field as dimension in your desired chart.

Otherwise, you can use calculated dimension in your chart using aggr() based on the Date field with some constraints to keep only 6 desired months.

Anyway you need to choose the current month (EOM-0) somehow.