topic Re: min and max data points in App Development

min and max data points

Krish2459_58 — Mon, 03 Feb 2025 06:01:55 GMT

Hi, I have data like below. If you see the required output table below I need to show years with start and end data points. I can't supress zeros becuase I need to show Produts 5, 6.

Dimension: Year

Measure: Sum(Sales)

Prtoduct	Sales	year
1		2009
2	100	2010
3	300	2011
4	500	2012
5		2013
6		2014
7	600	2015
8		2016
9		2017

required output

Prtoduct	Sales	year
2	100	2010
3	300	2011
4	500	2012
5		2013
6		2014
7	600	2015

Re: min and max data points

JandreKillianRIC — Mon, 03 Feb 2025 06:14:59 GMT

Hi @Krish2459_58

I suppose you need to show years 1,8 and 9 as well? Im not seeing this in your output table.

If you just add the Sum(Sales) as a measure and Prtoduct and Year as a dimension doesn't this give you the desired result?

Regards Jandre

Re: min and max data points

Krish2459_58 — Mon, 03 Feb 2025 08:56:08 GMT

@JandreKillianRIC , I need to show all years between two points where data exixts. Just like required output table above.

Re: min and max data points

Chanty4u — Mon, 03 Feb 2025 10:14:13 GMT

Try this

If(Year = Min({1} Year) OR Year = Max({1} Year), Sum(Sales))

Re: min and max data points

diegozecchini — Mon, 03 Feb 2025 10:46:44 GMT

An alternative approach is

If(Year = Min(Aggr(If(Sales>0, Year), Product))
OR
Year = Max(Aggr(If(Sales>0, Year), Product)),
Sales
)

This ensures that for each Product, only the first and last year with sales are displayed.