Jump to content

i have one bar chart need to show this logic into that how can we

uday ullasala

Recommended Posts

Data to be included in the

value axis:

1. "plan1" values: unique count of [column1] data in [column2] except when [column2]="cancelled".

2. "plan2" values: unique count of [column1] data in [column2] when [column2]="Completed" and "Closed".

Category axis: [Date] >> Year >> Quarter >> Month For empty data in [Date], categorize under "NoDate" and colour the bars red (Red 255, Green 0, Blue 0).

[column1] and [column2] are string data types

[date] is date dat type

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...