topic Re: How to have fixed/static dimension? in App Development

How to have fixed/static dimension?

newmcm — Thu, 02 May 2019 14:45:45 GMT

Hi All,

I have 3 columns in my mock up data. i.e. Unit, Epi_month, Name.

I plotted them on a graph, dimension: Epi_month, measures: Count(distinct name)

I have a filter: Unit.

When i filter for a unit, the graph and dimension reduces to:

Is there anyway I can continue to show -11 to 10 in the dimension. So those missing values are shown as 0 in the graph?

Edit: attaching my mock up data as well.

Re: How to have fixed/static dimension?

benvatvandata — Thu, 02 May 2019 15:40:09 GMT

See if changing your measure to this works:

count({1} aggr( count([distinct name]), Epi_month))

- Ben

Re: How to have fixed/static dimension?

rubenmarin — Thu, 02 May 2019 19:26:26 GMT

or maybe:
Sum({1} aggr(count(Name), Epi_month))

Re: How to have fixed/static dimension?

newmcm — Thu, 02 May 2019 23:24:21 GMT

Hi, is this for the measure or dimension?

Re: How to have fixed/static dimension?

newmcm — Thu, 02 May 2019 23:27:15 GMT

@benvatvandata wrote:
See if changing your measure to this works:
count({1} aggr( count([distinct name]), Epi_month))

- Ben

Wouldn't this makes my filter for useless already?

Re: How to have fixed/static dimension?

newmcm — Thu, 02 May 2019 23:45:02 GMT

@rubenmarin wrote:
or maybe:
Sum({1} aggr(count(Name), Epi_month))

Thanks! this works wonder!

Would you be able to explain the rational/logic behind please?

Re: How to have fixed/static dimension?

rubenmarin — Fri, 03 May 2019 06:37:47 GMT

Hi, it counts Name's for each Epi_month, all inside a sum to keep the value ofthe insider Sum, and using {1} to ignore selections and allow to show all dimension values.

It's very similar to the one posted by @benvatvandata, just changed the Count by a Sum, because the count will return 1, but the sum keeps the value of the insider Count().