This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi All,Just looking for an option in which we can do a Till Date Calculation in a Pivot table.i.e. For Example for a company "X" we have data for every months (measure column : Amount) from Mar-2022 and if I am running the report in May-2024, then m...
Hi All,Is it possible to embed a Incorta report on a SharePoint page? If yes, what steps needs to be followed and what all limitations we can face (i.e. availability of Filter, Bookmark etc.)Regards,Mritunjay Sinha
Can we utilized Incorta to integrate ArcGIS as it can be very helpful tool for various analytical problems especially for various organization with domain of Transportation and Manufacturing.
Hello Gurs,I am new to trying to write Pyspark query in incorta to filter a data for last week (Week starts from Monday and Ends on Sunday) But I am getting Transformation error (error log attached) while trying to save the query <<query attached>> a...
Hi @Prince , Thanks for reply, I am looking to develop a dashboard similar to " Tracking Adoption" dashboard.The expectation from this dashboard to give us the trend for usage of Incorta across my organization and other different KPI in respect to u...
Hello Gurus,I tried to convert the Julian date to a calendar date with below from pyspark.sql.functions import from_unixtime, unix_timestamp# Create a DataFrame with a Julian date columndf = spark.createDataFrame([('2459603',), ('2459604',), ('24596...
Hi @RADSr , after creating the MV table, the dates which were not overlapping (i.e for the given example, For the month of Feb, date 01/01/2023, 01/02/2023 is missing if I use standard calendar month name (for calculating Net Cost) and Date 02/01/202...
Thanks @RADSr for the feedback but I can't use the join between Table A and Table B as both tables is joined individually with 2 different calendar table ( table A is joined with Standard Calendar table whereas table B is joined with Custom Calendar...
