I have an order date and order count columns, i want to plot this to a vertical bar chart. And in each bar i want to show the aggregation of order counts of current date , previous week same day and previous year same date.
So I used the function
periodOverPeriodLastValue(sum(order), {Order Date},WEEK, 1) , periodOverPeriodLastValue(sum(order), {Order Date},MONTH, 1)
and getting correct value in chart for 7 days sample. There is filter with order_date having condition before and end date parameter selected date. but I have an issue that the selected date does not having any data in dataset it is showing till last date having data in dataset. Actually I need to show empty or no data for selected date in that chart if there is no data. Can you suggest any solution ?
Create a virtual date table that has your Current Date, Previous Week Same Day and Previous Year same date. Join this table with your Fact table as a Right Join(Virtual Date on the Right side of the join )
This way even when there is no data in your fact the date will show up. Use the date in your date table on the visual
Hi @Sheena123,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your initial topic or did the response provided above help with a solution?
If we do not hear back from you within 3 business days, I’ll go ahead and mark it solved.
Thank you!
Thank you @Giridhar.Prabhu @Brett for your solution