Display all dates as day name

[l26b]

hi, 

I have to create a barchart where I show Total Cost by Day - but I have to display all dates but instead of 2002-01-01 I have Monday as a value and so on and also I should have some demilitation in the chart by week number

Below is an example - I would have to have each of the days loaded into application - maybe 30 days but instead of the actual date to have Monday/Tuesday .... and also grouped by week

 how I can achieve this? 

Thank you

[Clement15]

Hello,

What dimensions and measure are you currently using?

[l26b]

hi,

event_date as dimension and volume as metric(sum of volume) 

[l26b]

also calculated week number from event_date

[Clement15]

Hello,

Creating a new column with WeekDay() to get the day of the week wouldn't help you?
If you have multiple years you can also use WeekName() which gives you the week and year in the same field.

[l26b]

hello, 

in a chart, this will display all dates under "monday" "tuesday" but I want all days from a month on a bar chart with volumes but instead of having written on the chart "2020-01-01' I want to have Monday and so on 

[Clement15 · Accepted solution]

Hello,

If you have created a WeekDay field, you can use as dimension:

Dual(WeekDay,event_date)

[eddyvargas]

Just create Field: Date("Date",'WWWW') as [Day Name],

[l26b]

this worked, thank you