Challenge #6 How to Display a trend of Sales Revenue

Rasha — Tue, 21 Feb 2023 11:58:19 GMT

As a Sales Analyst, I need to have a chart to determine a revenue trend over years and months,

I am looking for something like this:

It is straightforward, Enjoy it 😊

Re: Challenge #6 How to Display a trend of Sales Revenue

Wadeyy03 — Mon, 03 Apr 2023 10:49:36 GMT

Since No Dataset was given the solution would look like this:

1.Using the Dual X-Axis insight add the column TIME_ID to Grouping Dimension and setting the Date Part to Year and add a formula column to the Grouping Dimension and rename it Month-Year, containing the formula :

formatDate(

Challenge_6.SALES.TIME_ID,

'MMM-yyyy'

)

2. add the Amount_sold column to measure and rename it Revenue

topic Re: Challenge #6 How to Display a trend of Sales Revenue in Incorta Conundrums

Challenge #6 How to Display a trend of Sales Revenue

Re: Challenge #6 How to Display a trend of Sales Revenue