Tithi MondalBlog

Article6 min readUpdated

Report Dashboard Design: Charts, Dates and Exports

Report dashboard design for business apps: analytics screen UI, chart selection, a clear date range picker and export to PDF or Excel for owners.

Read inहिन्दीবাংলাमराठीதமிழ்తెలుగుગુજરાતી

Report Dashboard Design: Charts, Dates and Exports: cover illustration

The owner of a small tiffin service in Durgapur opens his sales report at night. He sees seven coloured charts, a date field he cannot edit and no number for today's total. He closes the app and asks his accountant on the phone. Report dashboard design is the work of arranging charts, numbers and filters so a person gets a clear answer without help.

Who reads a report, and what do they want to know?

Report readers are usually owners, managers and accountants. They do not want to explore data. They want an answer to a business question, then a way to share it.

Before designing, I list the questions in plain words. A shop owner asks: how much did I sell this week, which items sell most, who owes me money. A school manager asks: how many students paid, which class has most absences. Each question becomes one report section.

Readers often open reports on a phone at night, and on a laptop at month end for the accountant. Plan for both. If you are designing the whole overview screen, begin with my admin dashboard UI UX design article. This one goes deeper on analytics and reports.

How should an analytics screen UI be laid out?

An analytics screen should show the headline numbers first, one main chart second and the detail table last. This order follows how people read: answer, reason, proof.

A layout that works:

  1. Date range and filters at the top, always visible.
  2. Summary cards: 3 or 4 numbers such as total sales, orders, average bill and pending payments. Each shows the change from the previous period in words, such as "up 8,000 rupees from last week".
  3. One main chart, large, answering the page question.
  4. A table below with the exact rows behind the chart.

Keep the page to one question. If the owner needs sales and stock, make two reports and link between them. A page with ten charts is a gallery, not a report.

Label every card with plain words. "Net sales" needs a short help text if the term is not obvious. For microcopy ideas, see UX writing and microcopy for apps.

Which chart should you choose?

Choose the chart by the question being asked, not by what looks good. Each question has a chart that answers it fastest.

QuestionBest chart
How did it change over time?Line chart
Which item or group is bigger?Bar chart, sorted
What share is each part of a whole?A single bar split in parts, or a few labelled segments
What is the exact value?Table
What is today against target?Single number with a progress bar

Rules that prevent confusion:

  • Start bar charts at zero. A cut axis makes small differences look large.
  • Use no more than 5 colours, and add labels so colour is not the only signal.
  • Avoid 3D effects and many pie slices. People cannot compare angles well.
  • Sort bars from largest to smallest, unless the order is natural, such as months.
  • Write values on the chart when there are few bars. Do not make users guess from gridlines.

Test charts on a mid-range phone in sunlight. Light yellow on white disappears. See accessibility in app and web design and colour codes explained for contrast and colour choices. For a visual explanation approach beyond reports, read infographic design.

How should a date range picker work?

A date range picker lets the user choose the period a report covers. It must offer ready choices first and a custom calendar second, and it must always show the chosen dates in words.

The design:

  • Presets in a list: Today, Yesterday, Last 7 days, This month, Last month, This financial year, Custom.
  • The selected range is displayed in the button itself: "1 Nov to 18 Nov 2026".
  • The custom calendar has two clear taps: first the start date, then the end date. Highlight the days between.
  • A compare option: "Compare with previous period".
  • On a phone, open the picker as a bottom sheet with large date cells.

Indian businesses often report by financial year, from April to March, so include it as a preset. Do not assume January to December. Also decide what "Today" means when the report is not updated live, and show "Updated 10 minutes ago" near the date.

Be careful with time zones for teams that work across countries. State the zone if it matters.

How does export to PDF or Excel work?

Export gives the report to someone who is not in the app. The file must match what the user sees: same date range, same filters and same totals. Mismatch causes distrust quickly.

Use one Export button with two clear choices:

  1. PDF for sharing and printing. It carries the business name, report title, date range and the time of creation. Charts are included and the layout fits A4.
  2. Excel or CSV for an accountant who wants to work with the numbers. It holds the full rows, with plain column names and no merged cells.

Show a message after tapping: "Report ready, downloading". For large reports, say it will arrive by email or WhatsApp. On phones, the file opens in the default app, so check that a PDF reads well on a small screen.

Add a share-by-WhatsApp action. Many owners send reports to partners and accountants this way. If a report includes tax figures, the business must confirm the required fields and format with its accountant before using the export for filing.

What is the main task, step by step?

The main task is answering a question and sharing the answer. For the tiffin service owner asking "how was last week", the flow looks like this.

  1. He opens Reports and sees Sales as the default report, already set to Last 7 days.
  2. Summary cards show total sales, number of orders and pending payments.
  3. The line chart shows each day. He taps the lowest day and sees "Sunday: 6 orders".
  4. The table below lists orders, and he filters to Unpaid.
  5. He taps Export, chooses PDF and sends it by WhatsApp to his accountant.

Count the taps. Five steps, no setup. That is the target. A user should never have to build the report before reading it.

What mistakes make reports hard to trust?

Reports lose trust when numbers do not match across screens or when the reader cannot tell what period they show. These are the failures to remove.

  • Different totals on dashboard and report. One definition of each number, used everywhere.
  • Unlabelled dates. Always show the period in words.
  • Too many filters before any data. Show data first, then let users narrow it.
  • Charts with no empty state. Explain what is missing and why, see empty states, loading and error screens.
  • Animated charts that delay reading. Keep motion short or none.
  • Export that differs from the screen.

For long tables behind reports, see data table design for web apps.

If you are planning reports for a business tool, I can map the questions, choose the charts and design the screens through my UI/UX design service. You can also write to me through the contact section.

Frequently asked questions

What is the best chart for sales over time?

+

A line chart, because it shows the direction of change clearly. Use a bar chart when comparing a few separate periods such as months.

What presets should a date range picker have?

+

Today, Yesterday, Last 7 days, This month, Last month, This financial year and Custom. Show the chosen dates in words on the button.

Should reports export to PDF or Excel?

+

Offer both. PDF is for sharing and printing, and Excel or CSV is for people who want to work with the numbers.

How many charts should one report page have?

+

One main chart plus 3 or 4 summary numbers and a detail table. If the page answers more than one question, split it into two reports.

Working on something like this?

Tell Tithi what you are planning. You get a clear scope, a fixed price and a timeline before any work begins. I reply to every enquiry within 24 hours.

Your details go only to Tithi and are used only to reply to you. No newsletters, no sharing.