Bar Chart with Specific date ranges

[ZoeM]

Hello Community.

I am looking to create a chart with a dynamic range of dates.

All of my dates are coming into the dashboard through a date bridge and I have to use a date key to specify which range I am referring to when I create a chart e.g Date_Type={'VPP Date"}

Now I need to create a chart that will track the progression of sales between Date_Type={'Start Date'} and Date_Type={'VPP Date'}.

How can I build this? And I am assuming this will be a dimension?

Thanks in advance...

Zoe M.

[neelamsaroha157 · Accepted solution]

You can use your date field in the dimension as it is and use set analysis in the expression with the specified range which will automatically limit the the date range in the dimension.

[ZoeM]

Thanks Naleem. That worked, however, I am only seeing the Start Date and the VPP Date. How can I show all dates in-between?

The 'Show All Values' checkbox is grayed out under dimensions.

[neelamsaroha157]

Can you share a sample.