Hi, Thanks for your reply. I have 2 columns. Date and Amount. Date Amount 25/02/2022 100 31/03/2022 50 12/05/2022 100 10/09/2022 150 02/03/2023 75 31/03/2023 100 05/10/2023 200 13/11/2023 150 Now, Date filter has given in the dashborad and in a list/tabular table I want values differences as well as % differences of selected date from last fiscal year last date. If user select 10/09/2022 then value difference should come 100 (150-50) and percentage as 300% (calculating from 31/03/2022 to 10/09/2022). Calculations should be always from last fiscal year last date.
... View more
Dear All, I need to calculate (in VIYA 4.0) the value from last FY last date to selected date from report. Example: If user select 10Nov2023 from filter, then the value should calculate the difference and %difference from 31st Mar2023. If user select 05Jan2023 then value should calculate from 31Mar22 to 5th Jan2023. Thanks, S Bakshi
... View more
Hello all, I am working with Viya 3.4 and stuck with a calculated item. I need to create a calculated item which will be use in a "key value" object to show the results for overall and selected branch/city wise churn %. Data and expected results is like below. I need to show the result in "key value" object only, not in list or tabular object. Please guide how to create that required calculated item to get the result. Branch City Churn flag Mumbai abc 0 Mumbai xy 1 Mumbai abb 1 Mumbai wer 0 Delhi fg 0 Delhi sd 1 Chennai er 0 Chennai ty 0 Churn flag 1 = Exited Churn Flag 0= Active Expected Result in SAS VA in "Key value" object Total churn % 37.50% If select Mumbai from Filter then Churn % 50% Thanks in advance.
... View more