how to aggregate the month

ahmad4altamimi
Level 2
how to aggregate the month

hello guys i have dataset order. and i want to represent my white t-shirt and black t-shirt in month not day

* when i choose t-shirt category will come all the kind , just i need white and black

am sorry for my english bad

0 Kudos
1 Reply
imanousar
Level 3

You can use a prepare recipe with a step to parse the date or the formula to create the month column. 

Also for black and white shirt you can

a)select a filter recipe

b) inside the recipe, select the column and filter for the categories you like

c) prepare recipe and a step to keep rows on value 

 

Hope it helps.

0 Kudos