-
How do I get future data being populated to current year?
I have a requirement to show Next fiscal Year data into Current chosen fiscal year. So if user choses , FY 23, it should show data for Fy24 in 1 column. Please see below: If FY is selected, then monthly data is shown for current fiscal year. and similarly NextFy data (Fy+1) is also displayed like below. Please suggest.…
-
How do I get future data being populated to current year?
I have a requirement to show Next fiscal Year data into Current chosen fiscal year. So if user choses , FY 23, it should show data for Fy24 in 1 column. Please see below: If FY is selected, then monthly data is shown for current fiscal year. and similarly NextFy data (Fy+1) is also displayed like below. Please suggest.…
-
How Do I achieve below output based on data provided?
I want to transpose the below input format into expected output as below. Please suggest. Input : Month SEGMENT SITE Values Oct-23 Segment1 Site1 1000 Oct-23 Segment2 Site2 984 Oct-23 Segment3 Site3 234 Nov-23 Segment1 Site1 1100 Nov-23 Segment2 Site2 228 Nov-23 Segment3 Site3 2200 Output Oct-23 Nov-23 SEGMENT Segment1…
-
Calculate Previous Year metrics in DOMO
I have a requirement to calculate previous year's data (in monthly format - Month Over Month). So if user selects Fiscal year 2023, he should be able to get data for 2022. Only catch is that 2023 means Oct-22 to Sep23. So 2022 would mean data comparison between Oct-21 to Sep22. Any help would be greatly appreciated. Input:…
-
Calculate Previous Year metrics in DOMO
I have a requirement to calculate previous year's data (in monthly format - Month Over Month). So if user selects Fiscal year 2023, he should be able to get data for 2022. Only catch is that 2023 means Oct-22 to Sep23. So 2022 would mean data comparison between Oct-21 to Sep22. Any help would be greatly appreciated.
-
Data Comparison in a DOMO Dataset
I have a dataset which stores daily snapshots of data. It is set in append mode, so it captures daily run of that dataset . My requirement is to compare the data between current date and the user input date(which will be older than today's date) and see which are new records / updated etc. Data is as below: So latest date…
-
How do I achieve the below required format in DOMO?
I want to transpose the below input format into expected output as below. Please suggest. Input Month Year PLAT PY FY24 B Oct-2022 F 1.00 2.00 3.00 Nov-2022 F 1.00 2.00 3.00 Dec-2022 F 1.00 2.00 3.00 Jan-2023 F 1.00 2.00 3.00 Feb-2023 F 1.00 2.00 3.00 Mar-2023 F 1.00 2.00 3.00 Apr-2023 F 1.00 2.00 3.00 May-2023 F 1.00 2.00…
