Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
1. I currently have a bar chart which drills down into my various options. I am looking to display only Operations_scrapped. My chart is set up when I go to the properties, expression tab, in the definition box I was the following statement:
NumericCount (Scrapped_Operations). This does not work as it shows me all the operations and not just the scrapped ones. Can someone help me with the expression I need to use.
Thanks.
Hi Kelley,
In the expression, you can try filtering the results only for "Scraped" ones.You can use IF,ELSE condition something like this.
= Count(IF(<Your Field> ='Scraped',<Your Field>))
Hope this was helpful.
Regards,
Dinesh Sharma
Hi Kelley,
In the expression, you can try filtering the results only for "Scraped" ones.You can use IF,ELSE condition something like this.
= Count(IF(<Your Field> ='Scraped',<Your Field>))
Hope this was helpful.
Regards,
Dinesh Sharma