topic Re: Barchart Question in App Development

Barchart Question

raylang1 — Mon, 14 Oct 2019 13:39:00 GMT

I would like to have a Barchart default to X number of months but then still allow the user to select dates (years, months ) that will change the chart. I have been reviewing some solutions, and what I found so far is the ability to limit a Barchart to X number of months, but then the selections do not work.

Is what I am trying possible, or by limiting the Barchart to show X number of months, I take away the ability to have the end-user to select other dates for that chart?

I did try this in the dimension of the chart. It limits tothe last six months but does not allow for additional date selections.

=If([AdminDate] >= AddMonths(Today(), -6), [AdminDate])

Re: Barchart Question

thi_pham — Tue, 15 Oct 2019 07:56:31 GMT

I suggest to use Max(Total Date) instead of Today():

If([AdminDate] >= AddMonths(Today(), -6), [AdminDate])

Then, you can always get 6 most recent month from the last day of your selection.

You can also replace - 6 on above formular by a variable, and end user can edit the variable by a variable input extension, then it's more flexible to control how many months will be showed. (it is same to define a variable in fixed number limitation of dimension).

Re: Barchart Question

vunguyenq89 — Tue, 15 Oct 2019 08:29:34 GMT

Hi,

You can use function GetSelectedCount(<dimension>) to see if there is any current selections on fields Year/ Month/ Date. From this result, you can use an IF condition to decide whether to show all dates or default to 6 latest months.

For example, with this expression as a calculated dimension in your bar chart:

=If(GetSelectedCount(AdminDate) > 0, [AdminDate], If([AdminDate] >= AddMonths(AdminDate(), -6), [AdminDate]))

If there is a current selection on field AdminDate, it shows all values of AdminDate in the dimension
If there is no selection, it defaults to dates of 6 latest months

You can add Year, Month to the expression similarly as needed.

Hope this helps,

Vu Nguyen