Display data in a chart from dates sorted by weekdays

[#1]

Hi,

My chart is Time (x-axis) to Amount of Sales (y-axis). Time and Date are my key fields. All my data is loaded from an excel sheet as a crosstable.

I would like my chart to display the Amount of Sales from only Monday, or Tuesday, or Wednesday, etc.

I have tried a lot of things like the weekday() function, but nothing has worked for me.

Could you please help me?

Best Regards,

Lucas

[#2]

then in expression write this

Sum({<Dates={'>=$(vRollingWeek)<=$(vSelectedDate)'}>}Count)

[#3]

Hi,

I don't think that's going to work, because you have variables in the dimension which I don't where they come from and "Temp1: LOAD Date(Date#(Dates,'DD.MM.YYYY')) as Dates" always gives me an error. And I already found a solution, but thank you for your time!

[#4]

u can check your data now

[#5]

first u Use script then in front end u have to use two vairbles

[#6]

What are the definitions of the variables?

[#7]

I want this a as a result:

[#8]

vSelectedDate=Max(Dates)

vRollingWeek=vSelectedDate-6