Display all values on X-axis between the mentioned range even if there is no Data from source

Mounica · January 17, 2018

I have 2 params (start_date & End_date)
My Birt report is extracting data from DB to plot the BAR & crosstab.
I want to plot all the values in the range(start_date-end_date) on x-axis, even if data is not present in DB for a particular date I need to show empty(0).

Problem : If data is not present in DB for a particular date , X-axis is omitting that date and printing remaining with values.(data not extracted from DB?)
How to achieve the solution.

TIA

spulumat · January 22, 2018

we can use tableau.

CodeRookie · February 2, 2018

Mounica,
Hi! I don't know if you found a solution or not, but I think I may have the answer. I too had the same problem, and received the attached design from Clement Wong of OpenText. It will print out dates along the chart axis, even if the other axis value is '0'. Hope this helps.

Have a great day!

Scott

Display all values on X-axis between the mentioned range even if there is no Data from source

Comments

Categories