topic Re: Set analysis with inferior for measure in App Development

Set analysis with inferior for measure

etiennesan — Thu, 20 May 2021 06:39:03 GMT

Hello everyone,

I am trying to build a bar chart where my measure is called ForecastDate, but then I want to show the sum of the data for with Date is inferior to the ForecastDate of the current bar.

I tried with this formula:

Sum({<Date={"<$(=ForecastDate)"}>} QuantityDestructed)

But it is not working.

I found a few solutions of how to do it when using variables, but none about explaining how to do it when using the measure.

Thank you very much for your help!

Re: Set analysis with inferior for measure

MayilVahanan — Thu, 20 May 2021 07:33:58 GMT

Hi @etiennesan

Try like below, Create a variable like "vMinForecast"

vMinForecast =Min(ForecastDate)
Sum({<Date={"<=$(=Date(vMinForecast,'YourDateFormat'))"}>} QuantityDestructed)

Re: Set analysis with inferior for measure

etiennesan — Thu, 20 May 2021 07:41:34 GMT

Hello,

Thank your for your reply!

I guess I was not clear enough, I want this to be dynamic to be used in my graph. For example see below:

This is what I currently have. I want to add to each bar the sum that I am trying to write.

Am I using the right approach?