Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Use X-axis values as condition in an aggregation inequality

Hi,   I have three columns of data: salesmanID, clientID, and signingDate. I'd like to build a line graph that shows total number of clients by month. There will be a slicer for the salesmanID so e...
Need Help
Show and Tell
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
3 years ago

I would do a CLUSTERED COLUMN chart. Put MONTH(Signing Date) on the X azis. Put Salesman ID as the Legend (that groups all salesman together in one Monthly cluster. Then for the Y Axis do a COUNT(CleintID).

 

Do you have sample data you can share?