Column Chart does not show 0 value

Follow

Christopher Hols

April 27, 2020 17:43

Dear all,

 

I have a column chart that shows me purchases/users online for every day. Due to the covid-19 outbreak, we temporarily lost our customers, so the last data point I have is from early April 2020.

 

My colleague(dont ask why), wants to see the null values for the following days until today and in the future.

Meaning the x-axis values go until 27th of April, but of course no value on the y-axis

Is that possible?

 

Thank you!!

KR

Chris

0

• 

  An Y April 27, 2020 21:14

  Hi Chris

  Have you tried modifying  the formula to  replace null for a 0 ?

  https://documentation.sisense.com/latest/creating-dashboards/using-formulas/conditional-statements.htm#gsc.tab=0

  AY

  0

  Comment actions Permalink
• 

  ShiraS April 30, 2020 21:53

  Hi Chris,

  If you have a "Date" table with all wanted dates (which you can filter later) connected to a "Purchases" table.

  You can choose "Continuous Timeline"

  

  Shira

  0

  Comment actions Permalink

Please sign in to leave a comment.