Set Analysis table that works show no data in a specific case

[#1]

Hi All,

I have the following issue:

I have a set analysis tables that shows the installs sum of the last week.

My expression is:

sum({<is7daysDate={'1'}, isYesterdayDate=> } installviewAction)

this Usually works great, except for the following case:

In a specific partner I have no transactions for the dates 4/4/2014, 5/4/2014

When filtering by this partner and choosing the "is7daysDate" you see that these dates are missing from the listbox of dates.

In this case the graph shows no data and I see "no data to display".

Is there any way to make my graph show the dates that he does have data in?

And show 0 installs if there is no data?

Thank you,

Ella

[alexandros17]

You may uncheck "Suppress zero value" checkbox

[tresesco · Accepted solution]

Try:

Check 'Show All Values' in the dimension tab and enable 'Zero on Bars' in the presentation tab of the chart and uncheck 'Supress Zero Values'