topic How To Find Distinct Value In Line Chart in Insight Advisor

How To Find Distinct Value In Line Chart

HhAaRrIi — Mon, 28 Nov 2022 09:20:34 GMT

Hi Developer's

I Just Stuck With the Issue In Line Chart

I Have Taken 2 Trend Lines

1. Count(Email) For Total Count

2.count(Distinct Email) For Unique Count

And The Dimension Is Day/Date .

In Trend Line It Is Showing the Distinct(Email) In Day/Date Wise, But I Need Overall Distinct(Email) on Unique Count trend Line.

kaushiknsolanki — Mon, 28 Nov 2022 10:21:40 GMT

If you do the distinct at overall level it will show single value for each day. If you want that, you can try below expression

Count( total Distinct Email)

HhAaRrIi — Mon, 28 Nov 2022 10:46:34 GMT

Thank You Koushik