Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a peculiar requirement which is described below. Could anyone help with your inputs/suggestions.
Requirement: I am looking to have two time series overlaying each other on one chart. Requirement is to show meetings from one quarter and the sales from the following quarter to be on top of each other. In other words, did the work I did last quarter impact sales this quarter.
Regards,
Kishore
Maybe use a calculated dimension like
=daynumberofquarter( DateField)
and two expressions, something along these lines
=Count( If( InQuarter( DateField, Today(), -1), Meeting))
=Sum( If( InQuarter( DateField, Today() ) , Sales))
you may also use set analysis to restrict your records to specific quartes per expression.