Dashboards & Analytics Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! lookup formula/grouping

 I have three columns column 1 column 2 and column3. column1 is coming from a mv, column 2 is coming from a business schema and column3 is a look up formula. I have filtered on column1 and column2 as you can see the values are same for 2 rows for the...

Tarashah76_1-1715841648322.png

Resolved! Distinct count

can someone advise me a formulae for below case, i want to count the  no.of invoices with invoice amount <>0case(    Invoice Amount > 0,     distinct(        Invoice Number),         '0'    ))

MT10 by Ranger
  • 1716 Views
  • 1 replies
  • 2 kudos

Scheduled Report: Excel vs PDF

Dashboard has only one 1 tab only. There are 2 tables (insights) aligned horizontally.Issue:Excel format -- creates two tabs, 1 table/insight per tab.PDF format -- looks exactly like the dashboard, 1 page only.Question: Is there a way for the Excel f...