
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
how I can achieve this?
Thank you
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
If you have created a WeekDay field, you can use as dimension:
Dual(WeekDay,event_date)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
What dimensions and measure are you currently using?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
event_date as dimension and volume as metric(sum of volume)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
also calculated week number from event_date

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
If you have created a WeekDay field, you can use as dimension:
Dual(WeekDay,event_date)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just create Field: Date("Date",'WWWW') as [Day Name],

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
this worked, thank you
