how to restric dates when total experssion value is zero

[Anonymous]

Hi team,

i am facing one issue

ISSUE:

i need to check total metric values date wise .

if total metric value is zero in particular date then i need to restrict that date in variable level or in QVD Script level

note:

if metric is variable or some calculated columns then how i call in script level

please see the attested QVW file

Regards,

brahma

[Gysbert_Wassenaar]

In that case don't change the script at all. Change the chart expression to filter out the 0 total values: sum({<total={'<>0'}>}total)

[Anonymous]

that approaches are i tried but i have some restriction like in my dashboards i have bulk date nearly 70 laks that time i can"t use above suggestions that my restriction.that way i am asking more advice's and more suggestions

Regards,

Brahma

[Anonymous]

hi Gysbert Wassenaar ,

if you dont mind could you please give more information on your suggesstion?

Regards,

Bobbby

[Gysbert_Wassenaar]

Change the expression in you chart

From:

total

To:

=sum({<total={'<>0'}>}total)