data according to day wise

[capriconuser]

i have a data like this 

date  values 

01-01-2018    5000

01-02-2018  4000

01-04-2018   6000

01-08-2018   7000

02-01-2018  5000

02-12-2018   6000

and so on data like this 

now i want when i select month from filter i want data according to days like this  

Branch    Month     

abcbrach  jan        01  02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 

                                    5000 4000 6000         7000

how  i do this but this seems like long table so is any other possibilities for this if not then i how i get above data format ?

[swapniltaz]

Hi ,

You can achieve this by creating following variables:

vDay = Date(Date#(date ,'MM-DD-YYYY'),'DD')

vmonth= Date(Date#(date ,'MM-DD-YYYY'),'MMM')

Use vMonth for filter and vDay as Dimension for u r chart

[PrashantSangle]

create master calendar.
for how to create master calendar, search on community , You will get multiple thread use appropriate thread

Regards,
Prashant Sangle