Challenge #6 How to Display a trend of Sales Revenue

[Rasha]

 

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 😊

[Wadeyy03 · Accepted solution]

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