topic Re: Form separate columns for the status in App Development

Form separate columns for the status

Baavik — Fri, 15 Nov 2024 21:11:52 GMT

Hi,

I have the data of 3 month end sales with vMaxDate as today and vMonthEndMinus1 as last month data.

Now by comparing Jan, Feb, Mar sales-

if all the 3 values are same - status is 'Same'

if current sales > previous sales - 'Improve'

if current sales < previous sales -'Deteriorate'

The expected output is , 3 separate columns are needed for each status with total count of Status.

Need help in the logic to form separate columns in back end. Thanks !!

Taoufiq_Zarra — Fri, 08 Dec 2023 22:15:58 GMT

@Baavik if I understood correctly

from this input :

you can add table or chart and ;

dimension : Product

measure 1 : Count(If(Status = 'Improve', [staff id])) -> Improve in the name

measure 2: Count(If(Status = 'Worsen', [staff id]))-> Worsen in the name

measure 3: Count(If(Status = 'Stable', [staff id])) -> Stable in name

the output:

Baavik — Mon, 08 Jan 2024 10:16:54 GMT

@Taoufiq_Zarra - Thanks for this!!

But I need to get the status column based on the comparison of selected months data.

User wants to select any 2 random months from the Month filters and compare data in the same table as below -