topic Re: Display all dates as day name in App Development

Display all dates as day name

l26b — Tue, 10 Dec 2024 11:32:19 GMT

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

Re: Display all dates as day name

Clement15 — Tue, 10 Dec 2024 14:31:38 GMT

Hello,

What dimensions and measure are you currently using?

Re: Display all dates as day name

l26b — Tue, 10 Dec 2024 14:37:54 GMT

hi,

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

Re: Display all dates as day name

l26b — Tue, 10 Dec 2024 14:38:14 GMT

also calculated week number from event_date

Re: Display all dates as day name

Clement15 — Tue, 10 Dec 2024 14:44:04 GMT

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.

Re: Display all dates as day name

l26b — Fri, 13 Dec 2024 10:10:35 GMT

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

Re: Display all dates as day name

Clement15 — Fri, 13 Dec 2024 13:41:18 GMT

Hello,

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

Dual(WeekDay,event_date)

Re: Display all dates as day name

eddyvargas — Fri, 13 Dec 2024 14:26:20 GMT

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

Re: Display all dates as day name

l26b — Fri, 13 Dec 2024 14:35:37 GMT

this worked, thank you