Current week

[soniasweety]

Hi all,

I want to display the dimension as  current week  like below

My date field is   Tran_Date

Day1

Day2

Day3

Day4

Day5

Day6       this is current week except sunday

how can I write the calculation condition? 

[prat1507]

Hi

Can you plz elaborate a bit.

Regards
Pratyush

[soniasweety]

hi

I want to show the bar chart  for current weekdays excluding sunday  with the attached format

   so how to achieve this?

dim= Tran_Date

measure= count(id)

[prat1507]

hi

You can exclude the dimension using this

=if(date(DateField,'WWWW')<>'Sunday',

pick(match(date(DateField,'WWWW'),'Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'),

'Day1','Day2','Day3','Day4','Day5','Day6')

Regards

Pratyush

[soniasweety]

Hi ,

thanks for reply. but   I need to show current week only

now your expression is showing to over all I think?

or else can I restrict current week in measure?    then how can I  ?

count(Id)

[soniasweety]

Hi sunny

any idea

Sunny Talwar

[shiveshsingh]

You can use the max week values in your expression..can you try this?

count({<Week = {"$(=Max(Week))"}>}ID)

[MarcoWedel]

Is there any particular reason for not continuing this question in your thread Display name ?

[soniasweety]

‌if I use this I vill get including Sunday also?

i Want to exclude Sunday in this

[soniasweety]

yyes that was different and now logic got changed by cliebt‌