1 2 Previous Next 18 Replies Latest reply on Jan 24, 2019 12:06 PM by sonam jha

# 2 different measure cal using single date filter for Side by Side Bar graph

Hi All,

I am trying to create two bar graph side by side ,One for today and another bar should change according to my date filter - parameter value.

Ex: if I choose date as 20th Jan 2018 and #no of days(Integer parameter) as 2 then my 2nd graph should display data of 18th Jan(20 Jan-2).

I have only one date filter which has been set to Today.(according to this filter my 2nd bar should change and 1st should stay constant for today).

I tried  if Date= today () for today's graph and then trying to cal 2nd graph based on DATEADD('day', -[# of Days], today()). Somehow i am not getting 2nd graph.

Could not able to attach Workbook as cannot upload the client data.

Any help would be appreciated.

Thanks,

• ###### 1. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Hope this helps.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: 2 different measure cal using single date filter for Side by Side Bar graph

I did try your calculation,does not seems to be working.

I am trying to create bar graph(side by side) based on  one dimension and  measures  (2 measures which is today and Previous Day) where i get only today graph and does not get 2nd graph (previous)

For Today:   Date= today () then some value

For previous day:  DATEADD('day', -[# of Days], today()) then some value.

Above 2 measures in my row self and dimension in y column self.

Thanks,

• ###### 3. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Don't understand the failure very well. please check already attached workbook first.

You cannot see the attachment from inbox, go to original post.

Shin

• ###### 4. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Sonam Jha

Hope this  is what you are trying to do. Else please let me know. Attaching the workbook to check the same.

• ###### 5. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Thanks,

• ###### 6. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Unable to download attachment .Could you please re attach.I think because this workbook is created with new version and i am having 10.2 .

• ###### 7. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Unable to download attachment .Could you please re attach.I think because this workbook is created with new version and i am having 10.2 .

• ###### 8. Re: 2 different measure cal using single date filter for Side by Side Bar graph

10.2

.

• ###### 9. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Sonam,

I have attached the 10.2 version and also the csv file to go with it. Let me know if you still face issues, I can publish it in Public if that is the case.

• ###### 10. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Thank you so much for workbook.

I am trying to do something like this where(date will be some dimension in my case) .First graph should be constant and 2nd should change according to parameter I Enter.

I have also attached  my workbook.

And also please do suggest if i am doing wrong her.(I am trying to achieve comparison between today data vs Date selection -parameter data)

Any help would be really appreciated

Thanks,

• ###### 11. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Does this help?

See attached book.

Thanks,

Shin

• ###### 12. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Thank You,

Does not seems to be working when I set date filter. please find the attached workbook.

Thanks,

• ###### 13. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Sonam,

Just to understand, what you want to achieve here is to compare a measure (let's say Sum(Sales)) between 2 dates.. One Bar is going to be fixed for Today and the other bar will be changed based on the Parameter that user selects.. Correct?

• ###### 14. Re: 2 different measure cal using single date filter for Side by Side Bar graph

Of course, not.

Filter filters underlying data, and It won't work.

You need to use another date parameter instead.

today() needs to be replaced by [Parameter date]

Thanks,

Shin

1 2 Previous Next