Showing month daywise

[deepakqlikview_123]

Hello Team,

I want to show month daywise for selection.

For eg Jan-1,2,3--31

          Feb-1,2,--28

          Mar-1,2,--31

          Apr-1,2,--30

          May1,2,--31

Till December  1,2,--31

Please find attached photo for this

Can you please suggest how shall i proceed.

thanks

[its_anandrjs]

Try Like

Month&-&Day as MonthDay

Or

Add fields in the load statement like

Load

Month(DateField) as Month,

Day(DateField) as Day

From location;

And Then take a pivot chart

Dimension:- Month

Diemnsion:- Day

Expression:- Sum(Value)

[tresesco]

Create additional field in the script using Day(), like:

Load

          Date,

          Month(Date) as Month,

          Day(Date) as Day

Then, use a pivot table: Dim1: Month, Dim2:Day    then your expression. Pull your second dimension to column.

[MK_QSL]

Create Below in your script

Considering you have Date Field

Month(Date) as Month

Day(Date) as Date

Now Create a Pivot Table

Dimension

Month

Date

Expression

As per your requirements

Now Drag Day Field to the Right TOP

[deepakqlikview_123]

Hello Team ,

Thanks for reply but I would Like to show in below format

Jan	1	2	3	4				till	31
Feb	1	2	3	4				till	28
Mar	1	2	3	4				till	31
Apr	1	2	3						20
till
December	1	2	3	4				till	31

We are plotting line graph for detecting trend for that pupose for making day wise selection above is requirement.

Please suggest

Thanks

[its_anandrjs]

Update

Try like

Month&concat(Day,' ')

Or Better way is use

Dimension:- Month , Day

Expression:- Sum(Value)

and click on the Day field and drag over right upper corner of the pivot table then you see the blue arrow mark when it is horizontal leave the Day field there then you get answer as you want try the trick.

[MK_QSL]

Kindly provide sample data ....

[#8]

use two calculated dimension in pivot table: 1. month(Date), 2. day(Date) and the as expression use sum(value) (or whatever expression you have)

and then you have to drag the second dimension to the top

regards,

MT

[deepakqlikview_123]

Hi Manish,

Please find attached image.as per requirement the need is to plot dimension on x axis month with date as mentioned above.

And on axes there is percentage of absetism .

I have year month and day fields in my table.

Thanks

[fernando_tonial]

Hi, See the example.

Best Regards.

Tonial.