Display current fiscal week in barchart

[markgraham123]

Hi Everyone,

I have Sold Date, Fiscal week, fiscal month, fiscal year in my data model.

i was trying to plot a bar chart with curretn fiscal week in X-axis and sum(amount) in Y-axis.

If the application gets reloaded tuesday, i need to populate only monday, tuesday of the curretn fiscal week in the x-axis.

Can someone look into this pls.

[settu_periasamy]

May be try this

=if(Match(WeekDay(Today()),'Mon','Tue'),FiscalWeek)

[markgraham123]

Hi,

But, it my barchart should change when i reload it on wednesday.

It should be like MOnday, tuesday, wednesday of current week

[settu_periasamy]

i don't understand fully. But, if your day like Monday, Tuesday.. like that you can use

=DATE(Today(),'wwww')

you can use match or if function.

[markgraham123]

Hi,

Lemme be clear.

The bar chart should have the x-axis values of current fiscal week.

FYI I do have a field called fiscal week in the model.

[settu_periasamy]

May be you can try to change the Sum(Amount) as

Sum({<Yourdatefield={'$(=Today())'}>}Amount).

Just an assume. is it possible to post the sample?

[markgraham123]

Here the sample app. is friend.

I wanna see jus current week in x-axis.

[markgraham123]

the problem is i was not able to show the label on the x-axis.

[sunny_talwar · Accepted solution]

Try this in your set analysis:

{<Date = {"$(='>=' & Date(WeekStart(Today()), 'yourDateFormat') & '<=' & Date(Today(), 'yourDateFormat'))"}>}

[settu_periasamy]

Hi,

Check the attachment, May be help you..