Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
İn my chart ,
I have two expression
one of them is quantity of request opening date more than 30 days : =Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açık'}>} ISTEK_ACISTARIHI2) 1 aydan uzun süredir Açık İstek Adedi
other expression is only quantity of requests : count(IF(ISTEK_DURUM='Açık',ISTEK_DURUM)) Açık İstek Adedi
but in chart "açık istek adedi" (Blue one)expression is shown for only 30 days How can I make it show through all dates like red expression
How can I seperate these two lines?
Well, there´s a simple and "dirty" way.
Just add 0.0001 (or very small) value to one of your expressions
count(IF(ISTEK_DURUM='Açık',ISTEK_DURUM)) + 0.0001
Actually It didn't make result exact different
So, try bigger values, like 0.05 or 0.5
in the presentation tab of chart have u suprresed the zero values?
can u unchek that..
Hi.
QV shows values only if they exist. If you don't have data for that periods you have to add them in a script (even if you want just zero values).