topic Re: How to remove zeros from a bar graph in Management & Governance

How to remove zeros from a bar graph

Buddika — Tue, 09 Mar 2021 19:55:53 GMT

I want to visualise hospitalisation data on a special day, day after that special day and compare it with previous week.

But my graph shows zero values. can you help me to remove that from my graph.

I used if statements to define A day and day after A day in my script.

Re: How to remove zeros from a bar graph

Anil_Babu_Samineni — Tue, 09 Mar 2021 19:59:50 GMT

There are many ways to remove such. If you help us with sample document to demonstrate the same we will try to fix otherwise on assumption, You can try expression (If your expression is Sum(Measure)) it should be this

Sum({<WeekDay={"=Sum(Measure)>0"}>} Measure)

Re: How to remove zeros from a bar graph

Buddika — Tue, 09 Mar 2021 21:09:52 GMT

My expression is count({<alcohol={'Y'}, day_after_A_day = {'1'}}>} ed_id)

Definition of A day and day after A day is as follows (in script)

if(Month(aedArrivalDateTime)='Dec',
if(Day(Date(Floor(aedArrivalDateTime)))< '8',
if(WeekDay(Date(Floor(aedArrivalDateTime)))='Sat' , 1, 0), 0), 0) AS A_day,

if(Month(aedArrivalDateTime)='Dec',
if(Day(Date(Floor(aedArrivalDateTime)))< '9' and (Day(Date(Floor(aedArrivalDateTime))))> '1',
if(WeekDay(Date(Floor(aedArrivalDateTime)))='Sun' , 1, 0), 0), 0) AS day_after_A_day,

The graph shows that the value is zero on Sunday because A day is a Saturday.

Thanks

Re: How to remove zeros from a bar graph

Buddika — Tue, 09 Mar 2021 21:29:50 GMT

Hi,

My expression is count({<alcohol={'Y'}, day_after_A_day = {'1'}}>} ed_id)

Definition of A day and day after A day is as follows (in script)

if(Month(aedArrivalDateTime)='Dec',
if(Day(Date(Floor(aedArrivalDateTime)))< '8',
if(WeekDay(Date(Floor(aedArrivalDateTime)))='Sat' , 1, 0), 0), 0) AS A_day,

The graph shows that the value is zero on Sunday because A day is a Saturday.

Thanks

Re: How to remove zeros from a bar graph

Anil_Babu_Samineni — Wed, 10 Mar 2021 06:03:25 GMT

Can you please share sample data set to look?

Re: How to remove zeros from a bar graph

Buddika — Wed, 10 Mar 2021 20:03:43 GMT

Pls see the attached data set.

Thank you