Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working with the below data
Date | Sales (Thousands) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
I need to calculate the ratio of sales on first day of month to sales on last day of month. I am trying to display this in a KPI box but dont understand what expression to use. All help greatly appreciated.
Hi,
As variant for your data in attached file.
Regards,
Andrey
Suppose you have :
load
Date, Sales
from source;
You'll just have to create Month of Year field:
LOAD *, Month(Date)&'-'&Year(Date) as MonthYear;
load
Date, Sales
from source;
Than, in your chart, choose as a Dimension: MonthYear
As a measure: Sum(Sales)