Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
l26b
Contributor III

Display all dates as day name

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

 
 

l26b_4-1733830324888.png

 how I can achieve this? 

 

Thank you

 

 

 

Labels (1)
1 Solution

Accepted Solutions
Clement15
Partner - Specialist

Hello,

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

Dual(WeekDay,event_date)

View solution in original post

8 Replies
Clement15
Partner - Specialist

Hello,

What dimensions and measure are you currently using?

l26b
Contributor III
Author

hi,

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

l26b
Contributor III
Author

also calculated week number from event_date

Clement15
Partner - Specialist

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
Contributor III
Author

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
Partner - Specialist

Hello,

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

Dual(WeekDay,event_date)

eddyvargas
Contributor III

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

l26b
Contributor III
Author

this worked, thank you