topic Re: Chart Default 7 days unless dates are selected in App Development

Chart Default 7 days unless dates are selected

mikeslade — Mon, 20 Dec 2021 21:08:46 GMT

Hi, hopefully someone can show me where I'm going wrong.

I have a chart that successfully shows only last 7 days based on a flag in the data using this set analysis:
Num(Sum({< [%Last 7 Days Flag] = {"Y"}>}[Transaction Volume]), '#,##0')

What I want to do is if a date is selected, then ignore the default and display as per the selection.

I tried the below to get the evaluate selected count and then show volumes depending on the result

if(GetSelectedCount([Transaction Date]) >0,
Num(Sum([Transaction Volume]), '#,##0'),
Num(Sum({< [%Last 7 Days Flag] = {"Y"}>}[Transaction Volume]), '#,##0')
)

This works when a date is selected, however if no date is selected the set analysis that worked before now displays all dates, but only values for the last 7 days and all the non 7 day values are showing as 0 and are not nulls.

I'm confused why it would work outside of the if statement, but behave differently within it.

Here is how the chart looks with the set analysis on it's own out of the if condition

Within the if condition, this now looks like this (The last 7 days are waaay over the right 🙂 )

Anybody have an idea?

Thanks.

Re: Chart Default 7 days unless dates are selected

settu_periasamy — Wed, 09 Sep 2020 11:01:41 GMT

Hi,

Did you try to suppress null values in the measure?

Re: Chart Default 7 days unless dates are selected

mikeslade — Wed, 09 Sep 2020 11:10:29 GMT

Thanks - I did try that, as I said in the post the strange thing is they are all showing 0 as values, and not nulls. (Interestingly, they are not actually 0, and if you select one of the dates then you it will work and show the true value.)

Re: Chart Default 7 days unless dates are selected

sunny_talwar — Wed, 09 Sep 2020 12:28:54 GMT

Just so we get this right, you are unchecking 'Include zero values' under Add-ons -> Data handling, correct?

Re: Chart Default 7 days unless dates are selected

dirk_fischer — Wed, 09 Sep 2020 12:31:11 GMT

Hi Mikeslade

if you Limit your Dimension with a formula like in the attached imageLimit dimension, you should get, what you're looking for.

Regards

Dirk

Re: Chart Default 7 days unless dates are selected

mikeslade — Thu, 10 Sep 2020 06:32:36 GMT

Just so I get this right, that would exclude genuine zero values?

Re: Chart Default 7 days unless dates are selected

mikeslade — Thu, 10 Sep 2020 06:44:58 GMT

Gah! Should have thought of that! Thanks.

I still don't quite understand why it doesn't work the way I tried originally, but thank you.

Re: Chart Default 7 days unless dates are selected

mikeslade — Thu, 10 Sep 2020 06:45:53 GMT

Arggh how do I unaccept this as solution!

Re: Chart Default 7 days unless dates are selected

dirk_fischer — Thu, 10 Sep 2020 09:23:28 GMT

Hi Mikeslade

does your last post mean, your problem is still not solved?

If you click on the 3 vertical dots, it gives you a context menu, where you can remove the solution flag.

Regards

Dirk

Re: Chart Default 7 days unless dates are selected

mikeslade — Thu, 10 Sep 2020 14:16:08 GMT

Oh No... you resolved, but I somehow managed to mark my own reply as a solution!! Figured it out and removed the solution against my response!

Thank you!