actual value and text to be screened

[oxbord]

Hi,

I would like to know if there's a way to screen a text in place of the actual value from a fact table.

an example:

in a column i have the date, and in another one some measure.

i have a column graph with on the x-axis, the date, and on the y-axis the measure. perfect

what i want to do is : in place of screening the date (in order) i want to screen the day of the week (in the same order as the corresponding dates)

for example: if i have on the x-axis:

01/01/2016 02/01/2016 03/01/2016 04/01/2016 05/01/2016 06/01/2016     07/01/2016 08/01/2016

what i want instead is :

Friday         saturday    Sunday       Monday     Tuesday     Wednesday    Thursday    Friday

I added a new column containing the corresponding day of the week from the date column, in the table i checked that i want to order the day column with the date column but i get an error message that tells me that i can't do that because for a given day there can be several different dates ( which is normal, in my example Friday -> 01/01/2016 and 08/01/2016) .

So what did is concacenate the date in front of each day(keeping only the first letter of the day of the week): 20160101F, 20160102S etc..

now i can sort these values directly and get the corresponding day of the week but it's very ugly and difficult to read...

so i was wondering if there was a way to order the values: 20160101F,20160102S etc.. normally but screen only for example only the last letter...

Is this possible with this product ? or is there another way to address this issue ?

Thank you for the help

[HarrisMalik]

@oxbord I don't know if I understood your problem correctly.

what if you use the date on x-axis, your measure on y-axis and day name in legend. It will give one distinct color to every day of week and you can still see the data per day?

A Suggestion: use of continous line chart can tell your story better in this scenario.

[oxbord]

Hello Harris, thank you for you answer,

Ok, The thing i didn´t tell is i already have a "day type" attribute in the legend...

i would like to day something like this:

[greggyb]

You could set the display format on your date field to one of the formats that includes the day name. Unfortunately we can't use custom format strings, so you're stuck with the options included, which are verbose.