Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community, When we do a sum(sales) expression graph with a dates dimension, is there anyway we can have a count for the number of days the
sum(sales) has a value? Lets say the graph has a dimension of dates for a year. Only 50 of those dates have any sales on them based on my current selection of item part. Is there away to count this 50?
try
Count(Distinct Total Date) for the total across the chart.
Marcsliving, you got it but I have another issue. I've got two expressions in the graph so the dimension of dates count gives a vlaue if the other expression has a value too. How can I count the dates in the graph for only one of the expressions?