topic Re: How to exclude the month that does not have data in bar chart? in App Development

How to exclude the month that does not have data in bar chart?

hosasahana — Mon, 01 Feb 2021 10:12:00 GMT

Hi All,

I have a bar chart with month as a dimension and a measure for its calculation. I want to achieve 2 things.

1)how can I exclude the months that do not contain any data? meaning that month's bar should not be seen.

2) for months that has data but does not satisfy the condition should show an "NA" in the chart .

Can this be achieved in script level?

Regards,

Sahana

Re: How to exclude the month that does not have data in bar chart?

Taoufiq_Zarra — Mon, 01 Feb 2021 10:28:12 GMT

@hosasahana if I understood correctly you need to uncheck :

Re: How to exclude the month that does not have data in bar chart?

hosasahana — Mon, 01 Feb 2021 13:08:27 GMT

Hi Taoufiq,

Thanks for responding..

This solution will help me to resolve for zero values, will this also help for my 2nd query?2) for months that has data but does not satisfy the condition should show an "NA" in the chart .how can I achieve this?

Regards,

Sahana

Re: How to exclude the month that does not have data in bar chart?

Taoufiq_Zarra — Mon, 01 Feb 2021 13:11:19 GMT

@hosasahana For 2 No

can you give more detail about condition and a sample data and the expected output ?

Re: How to exclude the month that does not have data in bar chart?

hosasahana — Tue, 09 Feb 2021 08:01:52 GMT

hi, sorry I cannot share the data as I am using many calculated measures. I shall try to explain as below:

I am concatenating data from multiple tables into a model table with few fields and keys.

later I will use only the model and a master excel with ID's joining with model for my UI.

so here there is a bar chart which shows me data for 2020 all months.

issue:

1)I want the bars to be shows only for the months' that have data >0 . (I want to do a avg in another chart using only the months that has data and exclude the zero months)

2)if data is present but does not satisfy the where clause in script, the bar should show up but can show NA.

can this be possible in script level wile loading ?

my month field can be restricted?